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 |
|
Alessandro
Starting Member
14 Posts |
 Posted - 2010-05-06 : 14:59:40
|
| I would create The database is a Microsoft SQL Server database withthe following specs:- hostname: localhost- username/password: dbuser/dbpassword- database name: clients- tables: client_infoHow can I create, with sqlexpress, a database in localhost?Wich role do I need for dbuser to extract data from clients in asp.net ? |
|
|
Alessandro
Starting Member
14 Posts |
Posted - 2010-05-06 : 21:19:19
|
| I do again:Database server: LOCALHOST\SQLEXPRESSDatabase Name: clientsDatabase User Name: dbuserDatabase Password: dbpasswordI would like that Database server: LOCALHOSTwithout sqlexpress. Is it possible?Where do I have to work?On the code, on Microsoft SQL Management or SQL server configuration? |
 |
|
|
Alessandro
Starting Member
14 Posts |
Posted - 2010-05-07 : 10:21:02
|
| any ideas? |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2010-05-07 : 16:26:04
|
| try query analyzer |
|
|
|
Alessandro
Starting Member
14 Posts |
Posted - 2010-05-08 : 13:51:39
|
| in sqlexpress there is not any query analyzer |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Alessandro
Starting Member
14 Posts |
Posted - 2010-05-09 : 13:25:52
|
| Thank you, it works.But if I try the connection I see:Login failed for user 'dbuser'. The user is not associated with a trusted SQL Server connection. |
|
|
|
Alessandro
Starting Member
14 Posts |
Posted - 2010-05-09 : 13:47:31
|
| I have solved the problem :-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Microsoft SQL Server connection
Tara Kizer