My database name : MyDatabase
Mode : Windows Authentication Mode (I choose it when I first install sql server 2000)
Using the abovementioned information, I create login using the following statements:
sp_addlogin @.loginame = 'iori'
, @.passwd = '225468'
, @.defdb = 'MyDatabase'
, @.deflanguage = 'english'
After I have compiled the statements, new login is successfully created. But I am having problem to log in into sql server when I try to connect to sql server through Query Analyzer.
I click on 'connect', then a pop up box appears, then I select (local) as my sql server, and in 'connect using', I select 'SQL Server authentication', and finally, I type in my user name as 'iori' and passward as '225468'. I get an error message:
Unable to connect to server IORI...
Login failed for user 'iori'. Not associated with a trusted SQL Server connection.
Can anyone help me in this?Make Sure MS Desktop Engine's service is running, u r giving your server name as (local), which seems to be ok, u can also give dot sign (.) instead , under windows authentication mode it should work
Check for MSDEngine service or install desktop engine if u dont have one. Post again if problem persists...gud luk
Regards
BSS|||Thanks, I have solved the problem.
No comments:
Post a Comment