'M圜onnObj.Open "Provider = SQLNCLI10 Data Source=OLDPC,1433 Network Library=DBMSSOCN Initial Catalog=ServerTestData User ID=sa Password=******** "ħ.I've followed ALL the help and links on setting the firewall, allowing ports on TCP and UDP. 'M圜onnObj.Open "Provider = SQLNCLI10 Data Source=OLDPC,1433 Network Library=DBMSSOCN Initial Catalog=ServerTestData Trusted_Connection=yes " AS WELL AS -> I've used the following connection string:
I've also removed AND re-added the User(administrator) password.Ħ. When trying to connect app to server, it seems that it is trying to connect as guest.
There is also a guest user wich i've switched on AND off to no avail.
Login failed error also occured.Ĥ.I've unchecked 'simple file sharing' in control panel/folders/view.ĥ.I've removed all other users from server pc and left only User as 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. Run as administrator - The name on login error "OLDPC\User" (User) is the administrator. Sql validated the windows user token, know who it is, but the user was not granted access.Ģ.Login id needs a profile - how do I create such profile?ģ. Failure to register an spn may cause integrated authentication to fall back to NTLM instead of KERBEROS.įrom previous posts i've picked up the following:ġ.I dont have login access to server. ip = 192.168.0.10Ī previous error reads = The sql server network interface library could not register the service principal name (SPN) for the sqlserver service. Database = ServerTestDataĬlient pc running xp sp3. sql server setup with windows authentication only.
Server 2003 installed, although running from xp. I am using SQL Server 2008 Enterprise edition. Token based server access validation failed with an infrastructure error. Below the setup and connection string and all checked already.įirstly my errorlog file error = 18456 Severity 14 State 11 (Login failed for user OLDPC/GUEST. I have been searching for the answer for 2 months, but still no success.
0 kommentar(er)
