Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mcoomer146
Starting Member
3 Posts |
 Posted - 2013-01-18 : 17:58:17
|
| 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"Can someone please help? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-19 : 02:44:54
|
| when you installed sql 2012, which user(s) did you configure for having access to server------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
mcoomer146
Starting Member
3 Posts |
Posted - 2013-01-19 : 08:15:32
|
| Im using Windows Authentication on the local server. But on the remote server I had a username and password. Would this matter? |
|
|
|
mcoomer146
Starting Member
3 Posts |
Posted - 2013-01-21 : 08:43:47
|
| I figured it out. The user I created on my local server didn't have the permissions it needed to connect. I gave it permission and presto. Thanks everyone for your help. |
|
|
|
|
|
|
connecting to local db