sql server express connection string and login
Hi there
I'm trying to connect to sqlserver express using dreamweaver mx. TYhey are both installed on the same machine (win 2000 server),
What I am confused about is the user and password, I have installed the example Northwind database and attempting to connect to it.
In dreamweaver I add a connection (SQL Server connection) , a template shows and I add the data:
Persist Security = false;
Data Source =mycomputer\sqlexpress;
Initial Catalog = Northwind;
User ID = ?
Password = ?
What do I put in the User ID, Password and how do I configure sqlserver (I'm using Server Management Studio).. As I said I already have Northwind under the database section? but don't know how to set permissions.. Thanks
[768 byte] By [
razmataz] at [2007-12-31]
That is a question for a big answer :-) Frist you did not tell if you want to use Windows or SQL Server authentication, assuming taht you use SQL Server authentication, navigate through the security node in SSMS and create a new login. Then map the login in the database tab / section of the dialog to a (new) database user. Give him a predefined role (db_owner,etc.) or configure the permissions for each object in detail (depending on your need). More about the predefined roles can be found in the BOL. Perhaps they are already capable for you.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
But the smaller answer is...
If you did a default installation of SQL Express, then you are using Windows Authentication and you don't put anything for User and Password, you remove them completely and replace with Integrated Security=SSPI, which will pass your user credentials to SQL Express. By default, this will work for members of the Builtin\Administrators group or Users/Groups that you have added to the SQLServer2005MSSQLUser$<computer name>$SQLEXPRESS group, both of which are members of SysAdmin Role.
If you want to give users who are not members of those groups, or you want to limit people permissions and not put everyone into SysAdmin (which is a good idea by the way) then you get to Jens' big answer.
Mike
