March 13, 2010 at 2:17 am
Hi,
Please can someone suggest me on this issue.
I have SQL Server 2005 and then I installed SQL Server 2008, for the first time when I launch SQL Server 2008 it asked me whether to import the SQL Server 2005 userid/passwords to SQL Server 2008, I clicked onm Yes and click ok. If I use ServerName/SQLExpress with Windows Authentication then it is working, if I use ServerName with same windows Authentication then it is not working and giving error like Login failed. However I have use Servername with windows authetication instead of ServerName/SQLExpress. Please someone suggest me.
Thanks,
Nanda
March 13, 2010 at 7:45 pm
If i understood correct, you have two instances on same machine one is default instance another one is named instance is correct? Did you check whether you are entering correct instance name? Under what account these instances services are running?
March 14, 2010 at 1:56 am
I got the solution for the issue, I have opened the SSMS with runas administrator and created window authentication user id in the logins. Then I am able to launch the SSMS with windows authentication without fail.
March 14, 2010 at 2:01 am
So you were trying to login with an account, which did not exist?
March 15, 2010 at 5:50 am
If u using express edition then u must specify servername \sqlexpress while connecting..
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply