I have SQL Server Express loaded on my local machine. When I connect to the server all goes well until I try to add a new table to a database, I am able to create new databases. I am receiving the following error Unspecified error (MS Visual Database Tools). After I close the error message and try adding a table again I recieve, Failed to connect to server CORPMIS933\SQLExpress (Microsoft.Server.SQLServer.Express.SQLEditors)
Additional information A connection was successfully established with the server, but then an error occurred during the login process. (provider shared memory provider, error:0 – No process is on the other end of the pipe)(Microsoft SQL Server, Error:233)
If I restart the server I am able to add tables to the database. But when I open Visual Studio .NET 2003 the server will stop running. I have reinstalled both pieces of software.
Any suggestions will be greatly appreciated
Mary