I'm not sure if I'm in the right spot. I'm moving my site from a remote server to my own computer using IIS8 on windows 8 pro. Everything works and I can access the site on the internet. The problem is the database is on a remote server using sql server
2012. I have sql server 2012 installed on my pc but when I try to connect to it, it says "Login failed for user 'NT AUTHORITY\LOCAL SERVICE"
Is there somewhere I can find directions on how to get this problem figured out?
Microsoft SQL Server Analysis Services
SQL Full Text host
SQL Full-text Filter Daemon Launch Service
SQL Server Integration Services Service
SQL Server Windows NT
IIS Worker Process
Internet Information Services
I'm not sure if this will help but the Local DB is a backup of the remote db. I was looking at the properties of the local DB and on the permissions page there is a user with connect permissions. do I have to add a new user to the db and use that username
and password?
m_coomer146
Member
37 Points
67 Posts
Connecting to local SQL server 2012
Jan 18, 2013 08:47 AM|LINK
I'm not sure if I'm in the right spot. I'm moving my site from a remote server to my own computer using IIS8 on windows 8 pro. Everything works and I can access the site on the internet. The problem is the database is on a remote server using sql server 2012. I have sql server 2012 installed on my pc but when I try to connect to it, it says "Login failed for user 'NT AUTHORITY\LOCAL SERVICE"
Is there somewhere I can find directions on how to get this problem figured out?
wmec
Contributor
6228 Points
3226 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 08:56 AM|LINK
Make sure the relevant DB services of the instance are up/started.
HuaMin Chen
m_coomer146
Member
37 Points
67 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 09:02 AM|LINK
What DB services are relevant?
Microsoft SQL Server Analysis Services
SQL Full Text host
SQL Full-text Filter Daemon Launch Service
SQL Server Integration Services Service
SQL Server Windows NT
IIS Worker Process
Internet Information Services
these are all running
wmec
Contributor
6228 Points
3226 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 09:16 AM|LINK
Try to connect to it using
Server_name\Instance_name
BTW, are you using Windows authentication?
HuaMin Chen
m_coomer146
Member
37 Points
67 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 09:24 AM|LINK
yes using Windows authentication
Data Source=myserver;Initial Catalog=mydb;Integrated Security=True
wmec
Contributor
6228 Points
3226 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 02:30 PM|LINK
Hi,
You said you had remote DB and local DB but did the problem happen for the remote DB or local one?
HuaMin Chen
m_coomer146
Member
37 Points
67 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 03:05 PM|LINK
everything works fine when the local site uses the remote DB but when the local site tries to connect to the local DB i get the error
m_coomer146
Member
37 Points
67 Posts
Re: Connecting to local SQL server 2012
Jan 18, 2013 10:06 PM|LINK
I'm not sure if this will help but the Local DB is a backup of the remote db. I was looking at the properties of the local DB and on the permissions page there is a user with connect permissions. do I have to add a new user to the db and use that username and password?
wmec
Contributor
6228 Points
3226 Posts
Re: Connecting to local SQL server 2012
Jan 19, 2013 01:25 AM|LINK
How is the local DB created? You can enable sa login on the DB.
http://sudeeptaganguly.wordpress.com/2010/04/20/how-to-enable-sa-account-in-sql-server/
HuaMin Chen
sanjayverma_...
Participant
1476 Points
350 Posts
Re: Connecting to local SQL server 2012
Jan 19, 2013 03:58 AM|LINK
Hi m_coomer146,
Use Data Source=.\SQLExpress;
OR Data Source=. ;
Hope it will help you