December 22, 2009 at 6:49 am
Hi,
i have upgraded all our servers to SQL Server 2008 and now i get following error, if I try to connect to a SQL-Server from local machine.
The errormessage is: The login is from an untrusted domain and cannot be used with Windows Authentication
Some Details
- Servername: SQL01
- DNS-Alias: DBS01
With SQL Server 2005 i can connect to my sql server locally with SQL01 and DBS01 too. After upgrade, i cannot conncect to sql server with DBS01.
Trying to connect with DBS01 from a remote-server works properly.
What is changed after SQL-Upgrade, that can cause this effect? Most time, I'm using in my connection strings DBS01. So all applications which runs locally cannot connect to this server 🙁
Any help is welcome.
Thanks
Daniel
December 23, 2009 at 12:48 am
Hi,
Check the following links this may be help
http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=357656%5B/url%5D
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
December 23, 2009 at 12:51 am
Also check the server name
Are u able to connect via ip
select @@servername
select serverproperty('servername')
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
January 5, 2010 at 7:25 am
Hi, thanks for quick answer.
@@ServerName = SQL01 (same as physical servername)
Yes, its possible to connect via IP (local and from remote machine).
It seems that there runs no processes on local machine, because there are no trouble at christmas ;-). So this is not a big problem for me, althoug it is not solved/explained.
I discovered this while moving some SSIS-Packages from another server to server SQL01. These packages using connectionstrings with DBS01. I changed this to SQL01 and now all runs properly.
Regards
Daniel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply