|
VictorC -> RE: LNSS 8 and MS SQL 2005 problem (13.Aug.2008 1:20:19 PM)
|
To make it clear, this is exactly my situation:
- server called BILBO, ip 10.0.0.5
- network using 10.x.x.x addressing
- on bilbo, there is SQL server 2005 sp1 installed, (i have full access)
- there is no firewall on intranet nic (10.x.x.x)
- installed latest LNSS on BILBO as administrator using (local) sql server for data (this "(local)" option selected during installation procces and it worked with sa login and password and continued installation...)
- run LNSS on bilbo and tryied to run "any" scan and... no success, it cant connect right way to sql server
- tryied to setup "database options" in LNSS with server names: local, localhost, 127.0.0.1, bilbo, 10.0.0.5, still same result: credentials problems (well i am using sa account and password and it IS right)
SO I
- installed latest LNSS on network machine (10.0.0.30) as administrator using (10.0.0.5) sql server for data (10.0.0.5 option selected during installation procces and it worked with sa login and password and continued installation...)
- run LNSS on bilbo and tryied to run "any" scan and... SUCCESS, it CAN connect right way to sql server
now tell me please..., what am i doing wrong :-(((
EDIT:
probably problem is this:
in SQL errorlog found this: Error: 18456, Severity: 14, State: 16.
well still dont know how to fix "state: 16" error :(
quote:
2008-08-13 20:38:52.76 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:38:52.76 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
2008-08-13 20:39:15.99 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:39:15.99 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
2008-08-13 20:39:17.84 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:39:17.84 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
2008-08-13 20:39:28.90 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:39:28.90 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
2008-08-13 20:39:42.05 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:39:42.05 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
2008-08-13 20:39:42.20 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:39:42.20 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
2008-08-13 20:39:42.23 Logon Error: 18456, Severity: 14, State: 16.
2008-08-13 20:39:42.23 Logon Login failed for user 'sa'. [CLIENT: 10.0.0.5]
found this http://forums.msdn.microsoft.com/en-US/vblanguage/thread/747f01b4-288d-49ae-ab85-0fdf34ea2bfa/
quote:
"Error: 18456, Severity: 14, State: 16" indicates that the session database could not be determined which may mean that the database is offline or the user does not have permissions to access the database. You can verify the name and location of the mdf file and make sure that the user has permissions to read and write the the file.
and also found this:
quote:
Mahesh said: [image]http://blogs.msdn.com/Themes/Blogs/paperclip/images/spacer.gif[/image]
I keep on getting this error intermittently and the user specified in the error log has got the correct permission.
2006-10-31 08:58:36.01 Logon Error: 18456, Severity: 14, State: 16.
2006-10-31 08:58:36.01 Logon Login failed for user 'AbsLayer'. [CLIENT: <local machine>]
2006-10-31 08:58:37.28 spid53 Starting up database 'AbsLayerRepository'.
I have added retry logic in my code which keeps on retrying the connection for the configurable amount of time, when I get this error I can see in my application log that its retrying the connection and most of the time it passes after 2 - 3 attempts but some time it goes up to 9-10 attempts so I feel it to be unreliable in the live system. Can some one please help me why this error occurs or is there any patch to resolve this issue.
|
|
|
|