Setting up SQL Server 2005
-
Hi there, I am very new to working with SQL Server 2005 and would like to configure it on my machine, but I have a problem. The application appears to be installed on my machine (it installed after VS2005) but I can't seem to create any databases or connect to any database servers from the configuration manager...its almost like its a stripped version I open configuration manager and it lists Services, Network Config and Client configuration...there is no options for importing databases, connecting to databases, creating databases like I am used to with SQL Server 2000. Can you help please? I can connect to the different SQL Servers using VS2005 though...its this just how SQL 2005 works or what? -- modified at 2:25 Friday 10th March, 2006
-
Hi there, I am very new to working with SQL Server 2005 and would like to configure it on my machine, but I have a problem. The application appears to be installed on my machine (it installed after VS2005) but I can't seem to create any databases or connect to any database servers from the configuration manager...its almost like its a stripped version I open configuration manager and it lists Services, Network Config and Client configuration...there is no options for importing databases, connecting to databases, creating databases like I am used to with SQL Server 2000. Can you help please? I can connect to the different SQL Servers using VS2005 though...its this just how SQL 2005 works or what? -- modified at 2:25 Friday 10th March, 2006
Hi I am using SQL server 2005 express edition. For that there is a separate tool called SQL server management studio 2005. Using that SQL server management studio 2005 I can do any thing like SQL 2000 server. Regards, Chandana.
-
Hi there, I am very new to working with SQL Server 2005 and would like to configure it on my machine, but I have a problem. The application appears to be installed on my machine (it installed after VS2005) but I can't seem to create any databases or connect to any database servers from the configuration manager...its almost like its a stripped version I open configuration manager and it lists Services, Network Config and Client configuration...there is no options for importing databases, connecting to databases, creating databases like I am used to with SQL Server 2000. Can you help please? I can connect to the different SQL Servers using VS2005 though...its this just how SQL 2005 works or what? -- modified at 2:25 Friday 10th March, 2006
This may be valuable for you . http://www.aspfree.com/c/a/MS-SQL-Server/SQL-Server-2005-Introduction-to-SQL-Server-Management-Studio/[^]
-
Hi there, I am very new to working with SQL Server 2005 and would like to configure it on my machine, but I have a problem. The application appears to be installed on my machine (it installed after VS2005) but I can't seem to create any databases or connect to any database servers from the configuration manager...its almost like its a stripped version I open configuration manager and it lists Services, Network Config and Client configuration...there is no options for importing databases, connecting to databases, creating databases like I am used to with SQL Server 2000. Can you help please? I can connect to the different SQL Servers using VS2005 though...its this just how SQL 2005 works or what? -- modified at 2:25 Friday 10th March, 2006
You need to install SQL Server Management System. You can download it from Microsoft.com. Illegal Operation Making Computer Software Talk
-
Hi I am using SQL server 2005 express edition. For that there is a separate tool called SQL server management studio 2005. Using that SQL server management studio 2005 I can do any thing like SQL 2000 server. Regards, Chandana.
Hi Chandana, When I installed VS 2005, SQL Server 2005 Express installed aswell, but I do not have the server management studio, I just have: -Configuration manager -Surface area manager -Error usage and reporting Thats it, does this mean I have installed all the components properly?
-
Hi Chandana, When I installed VS 2005, SQL Server 2005 Express installed aswell, but I do not have the server management studio, I just have: -Configuration manager -Surface area manager -Error usage and reporting Thats it, does this mean I have installed all the components properly?
hi yes you need to install SQL server management studio
-
hi yes you need to install SQL server management studio
Thanks its all sorted now...the express technical community preview addition has some bugs i have found!