145 reputation
212
bio website
location
age
visits member for 5 years, 3 months
seen Sep 10 '14 at 22:49

Jan
8
awarded  Notable Question
May
20
awarded  Popular Question
May
17
awarded  Notable Question
Jul
11
awarded  Popular Question
Apr
5
awarded  Popular Question
Mar
21
awarded  Popular Question
Oct
22
awarded  Popular Question
May
22
awarded  Popular Question
Jan
26
comment I cannot connect to my local SQL Server 2008?
@Wayne - Ok I tried that but still can't connect to (local). I tired connecting to "MSSQLSERVER" but I get "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)" but I am unsure if this was always what I was getting.
Jan
26
comment I cannot connect to my local SQL Server 2008?
No it is not a fresh install. What happened was I locked my windows account came back a bit later and tried to log in and all of a sudden it decided to make me a new account profile and I was never able to access may account again.
Jan
25
comment I cannot connect to my local SQL Server 2008?
@Wayne - Ya I tired all those above and turned off the firewall. This is from Management Studio 2008.
Jan
18
comment Can't Connect to (local) database
Do you happen to know how to get the necessary privileges? I tried to run the program as admin(what many articles said to try) but that does not work
Jan
18
comment I cannot connect to my local SQL Server 2008?
@Wayne - yes both instances are running.
Jan
17
comment Can't Connect to (local) database
Ok well I got to ask the people who setup the computer if anyone has that permission. I think there is some super admin account so hopefully that has it. Otherwise can I do a repair or does it have to be a full install?
Jan
17
comment Can't Connect to (local) database
How do I do this? I cannot access my old account. So it has to be through this account(It has admin rights)
Jan
17
comment Can't Connect to (local) database
I tired my host name and same error. I beginning to think I need to somehow setup this account to have access to the default instance.
Jan
17
revised Can't Connect to (local) database
added 342 characters in body
Jan
17
comment Can't Connect to (local) database
Ok I think I found it. I getting State 11 (see my edit)
Jan
17
comment Can't Connect to (local) database
I have C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\Log and C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Log which one should I be looking at and can I use notepad to open these?
Jan
17
comment Can't Connect to (local) database
How do I figure out what the hostname is? I want to get (local) working as it once did as it makes it so much easier with my .webconfig(I just have to specify local and not worry about it when I switch to another computers that may have different names but same database on it)