Home
»
Discussion Forums
»
Kserver Discussions - VSA
»
Article 10011: After I install a SQL service pack for Microsoft SQL server, I can't access Kaseya.
Subscribe via RSS
Share this
Similar Posts
Article 10003: I can't install the Kaseya Agent on my Kaseya Server.
by
LegacyPoster
on
Jun 22, 2007
Article 10023: Upgrade Kaseya MSDE to SQL Server
by
LegacyPoster
on
Dec 16, 2004
Article 10012: How do I apply Service Pack 3 to the Microsoft Desktop Engine (MSDE)?
by
LegacyPoster
on
Dec 9, 2004
SQL Server 2012 Service Pack 3
by
Rusty Franks
on
Feb 29, 2016
Deploying SQL service packs
by
LegacyPoster
on
Feb 3, 2009
View More
Details
0
Replies
0
Subscribers
Posted
over 16 years ago
Kserver Discussions - VSA
Article 10011: After I install a SQL service pack for Microsoft SQL server, I can't access Kaseya.
Posted by
LegacyPoster
on
Dec 16, 2004 11:52 PM
The information in this Article applies to:
Microsoft SQL Server 2000 (All versions)
Microsoft SQL Server 7 (All versions)
Kaseya Server (All versions)
Microsoft Windows 2000 Server (All versions)
Microsoft Windows NT 4.0 Server (All versions)
Problem
After installing a SQL service pack for the SQL 2000 server or SQL 7 server, logon to the Kaseya VSA web site fails and the Kaseya server service has stopped. The SQL service pack may have reset the authentication method on the SQL server to Windows authentication only. When applying the SQL service pack, the installation wizard may prompt for the SQL authentication mode. By default, the service pack installation wizard selects the Windows authentication method.
Resolution
The Kaseya VSA web pages and the Kaseya server require that authentication to the SQL server be allowed by the use of an SQL login ID and password.
To change the authentication method used by your SQL server after applying an SQL service pack:
From your
Start
menu, select
Programs -> MicrosoftSQLServer -> EnterpriseManager
.
Expand the list of Microsoft SQL Servers by clicking on
Console Root
folder, clicking the plus sign next to
Microsoft SQL Server
, and clicking the plus sign next to
SQL Server Group
.
Right mouse click your server machine's name and select the
Properties
menu item.
Select the
Security
tab.
Click the
SQL Server and Windows
Authentication selection in the
Security
section.
Click OK to close the
Properties
dialog box.
Stop and restart the SQL server.
Further information can be found at:
http://www.kaseya.com/kforum/view_topic.php?id=71&forum_id=9
Legacy Forum Name: Article 10011: After I install a SQL service pack for Microsoft SQL server, I can't access Kaseya.,
Legacy Posted By Username: jimalves
You have posted to a forum that requires a moderator to approve posts before they are publicly available.