在 sql server 2005 中设置本地服务器 [英] setting up local server in sql server 2005

问题描述

我想设置一个本地主机服务器来在 sql server 2005 上测试我的站点.我刚刚安装了 sql server 2005，我以前从未在此设置数据库.有一个登录屏幕，我尝试了一切，但它不会让我登录任何东西.我需要采取哪些步骤才能使其发挥作用.谢谢

I would like to set up a localhost server to test my site on in sql server 2005. I just installed sql server 2005 and I have never set up a database in this before. There is a login screen and I tried everything and it will not let me log into anything. What are the steps I need to do to get this to work. Thanks

推荐答案

我收到了同样的错误信息，当我将服务器名称设置为 "(local)\SQLEXPRESS"(SQLEXPRESS 是 SQL 的默认命名实例)时，它得到了解决服务器安装.如果你改变了它，你可以使用它代替这个)并保持 Windows 身份验证作为默认身份验证方法.

I was getting the same error message and it was resolved when i put server name as "(local)\SQLEXPRESS" (SQLEXPRESS is the default named instance for SQL Server installation. If you have changed it you can use that instead of this) and keeping windows authentication as the default authentication method.

问候，阿什温·考尔

这篇关于在 sql server 2005 中设置本地服务器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！