Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tanvirtonu
Starting Member
5 Posts |
 Posted - 2008-03-28 : 08:02:42
|
| I m using SQL server 2005 express edition and management studio express. I m still confused with some terms. What is the difference between a new server registration, a new login and a named instance? I installed sql express using default configuration. It shows that my server name is- TANVIR\SQLEXPRESS (where Tanvir is my hostname) and it uses windows authentication. I created a new log in from Security>logins in the object explorer of express manager. In the property of this new login I just put the login name and gave password under sql server authentication and leaving everything else as default. I have enabled tcp/ip for both sqlexpress and client protocol in Sql server configuration manger. YET, I cant log in using my new log in name and password. I got the following error-Cannot connect to TANVIR\SQLEXPRESS.ADDITIONAL INFORMATION:Login failed for user 'Tanvir'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)------------------------------I just want to know HOW to create a user with password in sql express edition. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-28 : 09:19:59
|
| Go server properties- Security- enable Windows and SQL authentication. You have to reboot server and start services for that. |
 |
|
|
tanvirtonu
Starting Member
5 Posts |
Posted - 2008-03-28 : 15:25:53
|
quote:
Originally posted by sodeep
Go server properties- Security- enable Windows and SQL authentication. You have to reboot server and start services for that.
Brother I don't know which properties u meant but I tried with the properties of my default instance-Tanvir\SQLEXPRESS.I enabled Windows and SQL authentication and set a login name and password but it still says-TITLE: Edit Server Registration Properties------------------------------Testing the registered server failed. Verify the server name, login credentials, and database, and then click Test again.------------------------------ADDITIONAL INFORMATION:Login failed for user 'Tanvir'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-28 : 15:35:10
|
| Right click Server and properties. |
|
|
|
tanvirtonu
Starting Member
5 Posts |
Posted - 2008-03-28 : 15:47:24
|
quote:
Originally posted by sodeep
Right click Server and properties.
IN NO WAY IT IS WORKING,I did tha exact way u said.1.Right click Server and properties and enabling sql server authentication.2. Set login name and a password3. stop the server instance as well as service and restart but when I select sql server authentication and put the specified login name and password....the same error says-TITLE: Connect to Server------------------------------Cannot connect to TANVIR\SQLEXPRESS.------------------------------ADDITIONAL INFORMATION:Login failed for user 'Tanvir'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-28 : 15:50:30
|
| Did you reboot the server? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-28 : 23:57:27
|
| >> my default instance-Tanvir\SQLEXPRESS.That sounds named instance instead. Double check if sql authentication is still enabled. |
|
|
|
|
|
|
Sql server user creation problem