I have been searching for the answer for 2 months, but still no success. Below the setup and connection string and all checked already.
Firstly my errorlog file error = 18456 Severity 14 State 11 (Login failed for user OLDPC/GUEST. Token based server access validation failed with an infrastructure error. Check for previous errors. [client 192.168.0.10])
I am using SQL Server 2008 Enterprise edition. Running on pc with XP SP3. Server 2003 installed, although running from xp. ip = 192.168.0.17
Name = OLDPC. sql server setup with windows authentication only. Database = ServerTestData
client pc running xp sp3. SQL server 2008 EE also installed. ip = 192.168.0.10
Connection string in vb6 sp6.
a previous error reads = The sql server network interface library could not register the service principal name (SPN) for the sqlserver service. error:0x54b, state 3. Failure to register an spn may cause integrated authentication to fall back to NTLM instead of KERBEROS.
From previous posts i've picked up the following:
1.I dont have login access to server. Sql validated the windows user token, know who it is, but the user was not granted access.
2.Login id needs a profile - how do I create such profile?
3. Run as administrator - The name on login error "OLDPC\User" (User) is the administrator. After numerous setting or setup changes as per another help link, I've tried to connect to server via management studio from this pc. Login failed error also occured.
4.I've unchecked 'simple file sharing' in control panel/folders/view.
5.I've removed all other users from server pc and left only User as administrator. There is also a guest user wich i've switched on AND off to no avail. When trying to connect app to server, it seems that it is trying to connect as guest. I've also removed AND re-added the User(administrator) password.
6. I've used the following connection string:
'MyConnObj.Open "Provider = SQLNCLI10; Data Source=OLDPC,1433; Network Library=DBMSSOCN;Initial Catalog=ServerTestData;Trusted_Connection=yes;" AS WELL AS ------------------->>>>>
'MyConnObj.Open "Provider = SQLNCLI10;Data Source=OLDPC,1433;Network Library=DBMSSOCN;Initial Catalog=ServerTestData;User ID=sa;Password=********;"
7.I've followed ALL the help and links on setting the firewall, allowing ports on TCP and UDP. I've also enabled tcp/ip in configuration, confirmed port number at IPALL.
8.I've changed port numbers and allowed them through firewall as well, no luck
9.I've named the ports through firewall as MSSQL with tcp port number as 1433 and UDP as 1434.
10.I've given all users under security in mangement studio all rights to the database.
As you can see, I have tried everything possible. I still get the error message though. WHAT AM I MISSING HERE?
Please help. I'm at a stage where I am considering moving to MySql. It is only that i've spend so much money and time on sql server already.
Some links i've tried.
http://msdn.microsoft.com/en-us/library/dd207004.aspx WITH ALL LINKS FROM THERE...
http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx WITH ALL LINKS FROM THERE ....
http://blogs.msdn.com/sql_protocols/archive/2008/04/30/steps-to-troubleshoot-connectivity-issues.aspx WITH ALL....
http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspx AS WELL AS PART 2....
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=378&lngWId=5 WITH ALL LINKS...
AS WELL AS TONS OF POSTS FROM THIS FORUM.
As you can see, i've done a lot of research, but can still not solve this.