sqlserver2008tutorial.com SQL Server 2005 Express DBA Management Studio Database video tutorial 2008
SQL Server 2005 Managment Studio Express
Tags: 2005, 2008, database, dba, Express, Management, server, SQL, Studio, Tutorial, video
Performance and Optimization of SQL Server, .NET and Visual Studio
Tags: 2005, 2008, database, dba, Express, Management, server, SQL, Studio, Tutorial, video
Wonderful. Thanks a million. I am a brand new SQL Server DBA after having been a DB2 z/OS DBA for years.
FYI, I am using Vista 64 bit and had no problems.
@ilovcleavageverymuch Thank you for tthe suggestion.
for those who got problems….
in vista or window7
just do this…..
right click on the icon and select run as admin…
that’s it…
chao…..!!!
@baghul
nvm i fixed it i had to fully remove it and reinstalled
Hmm, not sure. check all the sql services, accounts assigned to them, also check for remote connection under configuration manager.
o and im running on windows vista i have gotten the sql to work before
but i uninstalled it then re installed it
TITLE: Connect to Server
Cannot connect to ..
ADDITIONAL INFORMATION:
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) (Microsoft SQL Server, Error: 2)
Is the SQL Service running. You can check that under Services (Ctrl Panel). If so use . (period) or machine name to connect to it. Cheers
Not sure what you mean. SQL server actually is a service that runs on a physical box. You will need to have a machine with the right OS on it b4 you can run SQL. Hope that helps.
lol i got a problem >.> i cant connect to the server