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.

All Forums  General SQL Server Forums  New to SQL Server Programming  First steps after installation

Author  Topic  Pignon Starting Member 2 Posts Posted - 2010-04-16 : 07:23:51 Hello, I'm totally beginner with SQL server. I installed SQL server express 2008 on my laptop. I tried a few things connecting trough Vis.studio 2008 express but got a lot of problems (cannot connect and then database unavailable in SQL server configuration manager). I first attached the sample database Northwind, then created a new database with 3 tables. I tried to connect from VS express (C#)to the new database impossible. Then tried Northwind ->OK. Back to config Studio Northwind was then not available. In fact I made a few iterations between config. manager and VS express and after it is like I cannot access the databases nor in Config manager and nor in VS studio. Question 1: When opening configuration manager only the service SQL server(SQLEXPRESS) is started. The 2 others services SQL server agent and SQL server browser are disabled. Is it correct ? Question 2: I wish to use windows autenthication. I created with Management Studio a user like ServerType:Database engine ServerName:MyPcName\SQLEXPRESS being logged on Windows with my login as an administrator. Is it correct ? Question 3: What procedure (step-by-step) should I respect to create a new database available then from Visual Studio ? Many thanks for the attention. Marc