SQL Server 2008 R2 First Time Login -


i've started work on new computer in had download software fresh.

i've download copy of sql server 2008 r2, , i'm trying connect sql server management studio without success. vaguely remember last time installed this, asked me choose between windows, or sql server authentication, didn't happen installation.

if try login via windows authentication (where username , password fields greyed out, localhost server name) gives following error:

"a network-related or instance specific error occured while establishing connection sql server. server not found or not accessible. verify instance name correct , sql server configured allow remote connections. (provider: named pipes provider, error: 40 - not open connection sql server) (microsoft sql server, error: 2)"

i have checked in sql server configuration manager, , bar via enabled.

if try sql server authentication, asks me username , password definiately have not set yet. also, under sql server services in configuration manager, there nothing there.

any appreciated :)

thanks

ps: don't know if it's worth mentioning running windows 7 virtual machine on mac.

are sure have correct instance name? if sql server 2008 r2 express edition default instance name .\sqlexpress.

also if using sql authentication connect try running sql management studio admin, if limited user identity might not mapped account in sql server yet believe administrators user group is.


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -