Connect ASP.Net application to localhost database

Question

0.00/5 (No votes)

See more:

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.

SQL

servername: 'localhost', seems to work fine

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–

SQL

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

just to name a few

Posted 28-Oct-15 9:18am

TheBigBearNow

Updated 28-Oct-15 9:45am

v3

Add a Solution

Comments

ZurdoDev 28-Oct-15 15:25pm

The error is very clear. You are trying to login with Administrator on the local machine but that account does not have permissions to SQL.

TheBigBearNow 28-Oct-15 15:34pm

when i change the login/username to any combination i do not have the right username.
How do i fix the issue? by giving admin permission to SQL ?

phil.o 28-Oct-15 15:36pm

Not clear whether it is MS SQL or MySQL. Please tag your question unambiguously.
And how did you copy the database? Are you 100% sure the original database contains credentials for the new one?

TheBigBearNow 28-Oct-15 15:41pm

I am using Sql Server 2012.
I used a .bak file to made a copy of the database. I imported it to the localhost.

phil.o 28-Oct-15 15:48pm

And can you connect to the new instance with SQL Management Studio?
Did you setup 'sa' credentials upon SQL Server installation on target host?

TheBigBearNow 28-Oct-15 15:58pm

i user servername : localhost and connect to my local database.
setting up credentials i am not sure.
I just went to security - login and i see 'sa' and i see that my 'WIN-LV74O1VFEK6\Administrator' account is both in the logins under SQL but i am not sure on the rights for these accounts i just see them under login? do i do something more to these besides having them as logins

phil.o 28-Oct-15 16:19pm

Please right-click on the WIN-LV74O1VFEK6\Administrator connection, and select 'Properties'. The third element in the left menu should be something like 'User Mappings'. For this user's mappings, select the TRANSIT database in the grid. Which permissions are set for this user on this database?

TheBigBearNow 28-Oct-15 17:03pm

public checkbox is marked
i changed admin account to transit

phil.o 28-Oct-15 17:22pm

You have to give this connection the sufficient mapping for the tasks it will have to accomplish against the database.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phil.o · Answer 1 · 2015-10-28T11:28:00

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 :)