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 |
|
leelu123
Starting Member
10 Posts |
 Posted - 2006-02-02 : 13:35:55
|
Hi,I have just installed sql server 2005 enterprise edition. I am totally new to sqlserver. I want to create a database in sql server and access that from my VB.net application. I couldn't find sql server management studio to create a database. can somebody help me with this...thanks,Leela |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-02 : 13:39:50
|
| You'll need to install the Client Tools to get Management Studio. You could use command line (sqlcmd) and issue a CREATE DATABASE statement, but that would be harder for a newbie.Tara Kizeraka tduggan |
 |
|
|
leelu123
Starting Member
10 Posts |
Posted - 2006-02-02 : 14:53:22
|
| Thanks Tara. As u mentioned, I installed the client tools and able to SSMS now. but ran into another problem.. unable to connect to sql server using SSMS..getting the following message...An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)Any help is appreciated...thanks,Leela |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
couldn't find SSMS