Trying to install WSUS but receiving Database Instance error

Hello

I am attempting to install the WSUS role on my SCCM 2012 SP1 server (Server 2012) but when I test the connection to the databse I get the error below:

Note:

Firewall is disabled (I am using a lab environment

Instance is vmsccm/mssqlserver

the sql server is installed on the system that sccm 2012 sp1 is.

Please help



August 4th, 2013 12:35pm

For the default instance, do not specify anything except the server name.
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2013 3:08pm

For the default instance, do not specify anything except the server name.
August 4th, 2013 3:15pm

Hi Jason,

So now that I as able to connect using the default instance i have another problem I am hoping you could help me with.<o:p></o:p>

Post install of WSUS fails when I try to connect WSUS updates to my sources directory. Here are several screen shots. the 3rd is the log file related the attempt to create sql db. 

Next window showed the folling error:

The post-install task failed. See below for details

Log file is located at c:\Users|balderos_admin\AppData\Local\Temp\tmp2A12.tmp

Post instll is starting 

Fatal error: Database creation failed

<o:p></o:p>

Free Windows Admin Tool Kit Click here and download it now
August 4th, 2013 3:57pm

Your account hasn't the permission to create the WSUS database, make sure your account has db create rights in SQL (I usually make my installation account Sysadmin on SQL).
August 4th, 2013 4:07pm

Your account hasn't the permission to create the WSUS database, make sure your account has db create rights in SQL (I usually make my installation account Sysadmi
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2013 4:33pm

That just confirms that your current domain admin account does not have the required SQL permissions. Have a look at the SQL permissions. Find an account that does have Sysadmain permissions and log on as that. Then add your domain admin account to Sysadmin
August 4th, 2013 4:43pm

Snap. Glad you got sorted
Free Windows Admin Tool Kit Click here and download it now
August 4th, 2013 4:45pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics