Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mikebird
Aged Yak Warrior
529 Posts |
 Posted - 2008-11-18 : 11:14:10
|
| Can't seem to change the service to login/password style without getting strange errors. The simplest setup.Works fine with Windoze authentication, but I need more remote access, from outside Windoze - Apple OS ODBC. I've tried this for other reasons too, and no success.So - properties of the service - Log on tab - currently on Local System account, working fine.Going for this account: [what needs to be in here?] domain\username can it be anything at all?then a passwordI can set it. Passwords have to match. Then the service won't start with this error: "Error 1058: The service cannot be started, either because it is disabled or because it has no enabled devices associated with it"Isn't this the most crucial part of any database? Serving it?Anyone help? |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-11-18 : 14:41:03
|
| You are actually looking at the wrong place. The Services applet is where you specify what login the service will run as. This account can be granted all sorts of permissions (typically local admin), and if ti is a domain account, can get permissions on resources outside the SQL Server (like a remote backup location).You want to go to SQL Server Workbench Studio, right click on the server in the Object Browser, and select the Security section. Then change this from Windows Authentication (note proper spelling here) to Mixed Authentication. After this, you will need to create SQL Authenticated logins for your Apple OS users. |
 |
|
|
|
|
|
Login Setup for SQLSERVER Service