将ASP.Net应用程序连接到localhost数据库 [英] Connect ASP.Net application to localhost database

问题描述

你好所有

我目前正在从服务器数据库工作。我制作了这个数据库的副本，现在它在sql server localhost上。

我一直在尝试将我的应用程序连接到localhost数据库，因此它将不再使用实时数据库连接





我尝试了很多不同的方法，这里有一些我一直在尝试的例子，

但是到目前为止每次尝试都是登录/用户名连接失败。

hello all
I am working from a server database currently. I made a copy of this database and now it is on sql server localhost.
I been trying to connect my application to the localhost database so it will not be using the live database connection anymore


I have tried many different methods here are some examples that i have been trying,
But so far every try the connection fails at login / username.

servername: 'localhost', seems to work fine

这里是我的错误

- 附加信息：无法访问服务器localhost上的数据库TRANSIT。详细信息：用户'WIN-LV74O1VFEK6 \Administrator登录失败



我尝试了很多不同的用户名组合 -

here is my error
- Additional information: Database TRANSIT on server localhost is not accessible. Details: Login failed for user 'WIN-LV74O1VFEK6\Administrator

I have tried many different combinations for username–

‘Root’
‘Administrator’
‘WIN-LV74O1VFEK6\Administrator’
‘WIN-LV74O1VFEK6’
‘’
‘dbo’
‘username’
‘user’

仅举几个

just to name a few

推荐答案

这里有两个链接可以更好地理解MS SQL Server登录配置：

MSDN - SQL Server 2012 - 创建登录 [ ^ ]

MSDN - ALTER LOGIN（Transact-SQL） [ ^ ]



关于这个主题的其他资源可以出现在任何体面的搜索引擎的第一页，特别是YouTube视频，如果你喜欢这种媒体。



勇气：）

Here are a couple of links to gain a better understanding of the MS SQL Server login configuration:
MSDN - SQL Server 2012 - Create Login[^]
MSDN - ALTER LOGIN (Transact-SQL)[^]

Other sources are available on the subject, which appear on the first page of any decent search engine, in particular YouTube videos, if you like this medium.

Courage :)

这篇关于将ASP.Net应用程序连接到localhost数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！