Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

So you decided to set up log shipping in order to establish a failover server, but what's next? Log shipping only takes care of keeping a user database in sync from one server to the other. In the ...

SQL Server 安装程序无法连接到数据库服务进行服务器配置。 错误为: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'. 有关详细信息，请参阅服务器错误日志和安装日志。有关如何查看安装日志的详细信息，请参阅 SQL Server 联机丛书中的“如何查看安装日志文件 ...

Is the SQL server running in Mixed mode or Windows Authentication mode only? If its the latter, it won't use SQL-Server only accoutns until you change the mode.

The first parameter ('BUCKSOFT\Marjorie') is the name of the SQL Server login you want to grant access to this database. You can supply a second parameter for the Database user name, but if you leave ...

What are the advantages of using Access as the front end to a SQL Server database? For starters, it’s likely that your client’s users will be more familiar with it, and it’s relatively easy to put in ...