questions from newbie

questions from newbie

• BtrGoneThanJail

  Use the SQL Server Management Studio Express Edition

  
  

• Martin_H2005

  Hi Glenn,
  
  thanks for your help. However, after doing your steps, the error message appears
  "User, group or role "username" already exists in the current database" (Microsoft SQL Server, Error: 15023)
  
  How can I fix this And I am sure the connection string is good, cause I can use it with another server :(
  
  thanks
  
  
  

• Sanjay Bhanushali

  You can download it here http://www.microsoft.com/downloads/details.aspx familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
  
  
  
  

• chemaster

  I am also new to the product. I just installed the 2005 Express with Advanced Services and rebooted my machine. Now I am looking to see how I can start the Management Studio Express. I do not see it in my program list and I did not receive any installation errors. Can you help me

  thank you very much

  
  

• BjeKa

  Hmm.. How I understand the error message is that the user is already configured to your database. Try to skip #2.

  Sorry for the delay in responding your forum. I only attend it during my free time. ;-)

  Cheers,
  Glenn

  
  

• QuinceArj

  Thanks. I have installed it. Now, after logging in, I can create new database (db1), create new user (new login ) with default db is the database just created above (db1). But, I cannot use it with my code
  
  StrDB="DRIVER={SQLServer};Server=localhost;UID=username;PWD=password;Language=us_english;Database=db1"
  
  
  What should I do now
  
  thanks
  
  
  

• Kebians

  If you want to use the SQL login, then you must create a new user from Management Studio Express.

  On creating a SQL user, go to Security-->Logins. Then create a new user, In the property page of the user, please set the following:

  1. General Tab--> Default Databse to logon
  2. User Mapping--> Map the databse that will be use
  3. Status --> Have the permsion to login

  Are you using Visual .NET 2005 If yes, use database explorer to help you with the connection string settings.

  Cheers,

  Glenn

  
  
• questions from newbie