无法连接到数据库

发布于 2024-10-20 15:08:44 字数 959 浏览 1 评论 0原文

我很困惑，被困住了，已经两个小时了。

这是我的连接字符串：

<add name="yafnet" connectionString="Data Source=localhost;Initial Catalog=Scirra;User Id=Gullanian;Password=12345;" providerName="System.Data.SqlClient" />

我得到：

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'Gullanian'.

我已经创建了数据库“Scirra”。我也尝试添加登录，但似乎没有任何作用。通过 Windows 身份验证登录 SQL 管理是我访问数据库的唯一方法。

理想情况下，我只想创建一个用户，并且该用户可以完全控制数据库。所以我可以运行脚本等。

这里有一些细节：

Microsoft SQL Server Management Studio                      10.50.1600.1
Microsoft Data Access Components (MDAC)                     6.1.7600.16385
Microsoft MSXML                     3.0 6.0 
Microsoft Internet Explorer                     8.0.7600.16385
Microsoft .NET Framework                        2.0.50727.4952
Operating System                        6.1.7600

我不知道为什么它说 v2 for asp.net，我所有的应用程序池都设置为 4.0。

原文

I'm baffled, and am stuck, and have been for 2 hours now.

Here is my connection string:

<add name="yafnet" connectionString="Data Source=localhost;Initial Catalog=Scirra;User Id=Gullanian;Password=12345;" providerName="System.Data.SqlClient" />

And I get:

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'Gullanian'.

I've created the database 'Scirra'. I've also attempted to add a login, but nothing seems to work. Logging into SQL management via Windows Authentication is the only way I can gain access to my DB's.

Ideally I just want to create a user, and that user having full control of DB. So I can run scripts etc.

Here's a few details:

Microsoft SQL Server Management Studio                      10.50.1600.1
Microsoft Data Access Components (MDAC)                     6.1.7600.16385
Microsoft MSXML                     3.0 6.0 
Microsoft Internet Explorer                     8.0.7600.16385
Microsoft .NET Framework                        2.0.50727.4952
Operating System                        6.1.7600

Idk why it says v2 for asp.net, all my application pools are set to 4.0.

分享到QQ

分享到微博