<div>
<blockquote>
I have a SQL/web-server with a general login for myself
</blockquote>
Is the general login for Web-Server or SQL Server instance?
</div>


> I have a SQL/web-server with a general login for myself

Is the general login for Web-Server or SQL Server instance?

<div>
Define &quot;it doesn't work&quot;. &nbsp;What is the error ?
</div>


Define "it doesn't work".  What is the error ?

<div>
Thank you for your quick response. :-)
</div>


<div>
<div class="content wysiwyg-content">
Hi out there.<br />
<br />
I have a - supposedly - basic issue. &nbsp;I have a SQL/web-server with a general login for myself. If I use that in a connection string, it doesn't work. I wonder if I need to create a login/user via the SQL Server Management Studio?<br />
Can anyone please give me a quick guide how to create a user/login I can use in a connection string like this:<br />
<br />
&quot;Driver={SQL Server};Server=SERVERNAME\<wbr />SQLEXPRESS<wbr />;Database=<wbr />databasena<wbr />me;Uid=use<wbr />rname;Pwd=<wbr />password&quot;<br />
<br />
Thank you.<br />
<br />
Best regards<br />
<br />
Ulrich
</div>
</div>


Hi out there.

I have a - supposedly - basic issue.  I have a SQL/web-server with a general login for myself. If I use that in a connection string, it doesn't work. I wonder if I need to create a login/user via the SQL Server Management Studio?
Can anyone please give me a quick guide how to create a user/login I can use in a connection string like this:

"Driver={SQL Server};Server=SERVERNAME\SQLEXPRESS;Database=databasename;Uid=username;Pwd=password"

Thank you.

Best regards

Ulrich

How to create a user/login for SQL Server Express to use in a connection string...

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.