Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 21, 2013 12:41 PM by m_coomer146
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?
Jan 18, 2013 08:56 AM|LINK
Make sure the relevant DB services of the instance are up/started.
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
Jan 18, 2013 09:16 AM|LINK
Try to connect to it using
BTW, are you using Windows authentication?
Jan 18, 2013 09:24 AM|LINK
yes using Windows authentication
Data Source=myserver;Initial Catalog=mydb;Integrated Security=True
Jan 18, 2013 02:30 PM|LINK
You said you had remote DB and local DB but did the problem happen for the remote DB or local one?
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
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
Jan 19, 2013 01:25 AM|LINK
How is the local DB created? You can enable sa login on the DB.
Jan 19, 2013 03:58 AM|LINK
Use Data Source=.\SQLExpress;
OR Data Source=. ;
Hope it will help you