What do i do if my sql server in the server explorer always has a red cross on it, if i click on it and then look in the properties window on state it says it is closed and therefore I cant work with my database. if i try and refresh it it gives me this error message"Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed"
tendaimare 0 Junior Poster in Training
G_Waddell 131 Posting Whiz in Training
Netcode 33 Veteran Poster
remove the existing one and try and add the database again to the server explorer
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.