Sql server Authentication Problem
-
Hi .... Iam new to dotnet and Sql server ... I want to install sql server in my system .. Ive 180 days trail version ... its installed but i cant able to login ... My System name is NARESH ... It asking about system name , username and passwords .. I gave "sa" , "sa" . But it is showling like unable to login with NARESH ... Plz help me ... Ive .net framework 2.0 in my system .. Thanks in advance Naresh
-
not getting where the probelm. however check this http://www.connectionstrings.com/[^] may help you
Regards KP
hiiiiii... k i think u didnt get it... k my problem is not about the database connectivity ... iam juz starting sql server ... i wanna practice queries ... So i installed Sql server studio 2005 management express edition ... i installed in my PC ... Its successfully installed .. but wen am going to use sql server it is asking about username and password for sql server connection enabling ... but i dont kw how to login .. the window options r like this ... Server Type : Database Engine Sql Server Compact edition Server Name : My system name or browse Authe mode : Windows Sql Server wen i click on Sql server Login : Pwd Connect cancel ----- -------- plz help me thanks in advance naresh
-
hiiiiii... k i think u didnt get it... k my problem is not about the database connectivity ... iam juz starting sql server ... i wanna practice queries ... So i installed Sql server studio 2005 management express edition ... i installed in my PC ... Its successfully installed .. but wen am going to use sql server it is asking about username and password for sql server connection enabling ... but i dont kw how to login .. the window options r like this ... Server Type : Database Engine Sql Server Compact edition Server Name : My system name or browse Authe mode : Windows Sql Server wen i click on Sql server Login : Pwd Connect cancel ----- -------- plz help me thanks in advance naresh
-
hiiiiii... k i think u didnt get it... k my problem is not about the database connectivity ... iam juz starting sql server ... i wanna practice queries ... So i installed Sql server studio 2005 management express edition ... i installed in my PC ... Its successfully installed .. but wen am going to use sql server it is asking about username and password for sql server connection enabling ... but i dont kw how to login .. the window options r like this ... Server Type : Database Engine Sql Server Compact edition Server Name : My system name or browse Authe mode : Windows Sql Server wen i click on Sql server Login : Pwd Connect cancel ----- -------- plz help me thanks in advance naresh
try to connect in Windows Authentication and after you conenct create one username and password then next time connect with SQL Server Authencation mode, that (SQL Server Authencation mode) require username and password. Or check rights for your created username.
I Love SQL
-
try to connect in Windows Authentication and after you conenct create one username and password then next time connect with SQL Server Authencation mode, that (SQL Server Authencation mode) require username and password. Or check rights for your created username.
I Love SQL
-
sssssssss....... i aslo done like this .... i created usrname , pswd for that ... iam getting the query enalizer ... but wer shud i get Enterprise manager in this scenario ...
-
no am not getting .... same error ....... unable to connect wat ive to do... is there any compatible verson of sql server ......
-
hiiiiii... k i think u didnt get it... k my problem is not about the database connectivity ... iam juz starting sql server ... i wanna practice queries ... So i installed Sql server studio 2005 management express edition ... i installed in my PC ... Its successfully installed .. but wen am going to use sql server it is asking about username and password for sql server connection enabling ... but i dont kw how to login .. the window options r like this ... Server Type : Database Engine Sql Server Compact edition Server Name : My system name or browse Authe mode : Windows Sql Server wen i click on Sql server Login : Pwd Connect cancel ----- -------- plz help me thanks in advance naresh
-
hope you might have installed SQL Server with Windows Authentication. if so, reinstall in mixed mode.
Regards KP
-
k ill do it now... Thanks for ur help... if i face any prob ill let u kw.. bye ... naresh
And please - don't use textspeak. It's very very irritating because I have to spend time inserting consonants and vowels into your sentences in order for them to make any sense.
Deja View - the feeling that you've seen this post before.