We have what we think is msde running on a box. No one knows the sa password.
I am in the domain admin group on Windows and the Windows admin group but
when I right click on BUILTIN\administrator, I don't get the "properties"
menu selection. I also can't create a new login.
A few weeks ago I was able to create a new login and a new database. I'm not
sure what happened. My windows login is not there anymore but I would have
thought I could use the BUILTIN\administrator login to admin the server.
Any ideas on how I can get control of the server?
Thanks,
Dan D.
Although I hate tools like these but try this tool if it works for you ...
http://www.nextgenss.com/sqlcrack.htm
Harman Sahni
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> We have what we think is msde running on a box. No one knows the sa
password.
> I am in the domain admin group on Windows and the Windows admin group but
> when I right click on BUILTIN\administrator, I don't get the "properties"
> menu selection. I also can't create a new login.
> A few weeks ago I was able to create a new login and a new database. I'm
not
> sure what happened. My windows login is not there anymore but I would have
> thought I could use the BUILTIN\administrator login to admin the server.
> Any ideas on how I can get control of the server?
> Thanks,
> --
> Dan D.
|||Thanks but I figured out the sa password. I'll keep this for future reference.
"Harman Sahni" wrote:
> Although I hate tools like these but try this tool if it works for you ...
> http://www.nextgenss.com/sqlcrack.htm
> Harman Sahni
>
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:E449D233-29E8-4ED0-AC95-2B4BF0FDC6D3@.microsoft.com...
> password.
> not
>
>
|||Dan
Log in SQL Server with Windows Authentication and run EXEC sp_password NULL,
'NewPass', 'MyUser
'
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:2264F204-A7B6-422A-95AC-0517B560C27C@.microsoft.com...
> Thanks but I figured out the sa password. I'll keep this for future
reference.[vbcol=seagreen]
> "Harman Sahni" wrote:
...[vbcol=seagreen]
but[vbcol=seagreen]
"properties"[vbcol=seagreen]
I'm[vbcol=seagreen]
have[vbcol=seagreen]
server.[vbcol=seagreen]
Showing posts with label admin. Show all posts
Showing posts with label admin. Show all posts
Tuesday, March 20, 2012
Monday, March 19, 2012
Cannot view reports but able to see ReportManager from different
My RS was installed on server which is accessed from 2 domains (lets
named Domain1 and Domain2).
Server belongs to Domain1 and RS service has admin privileges on
Domain1 as well. Viewing reports on Domain1 cause no problem. But I
have users in Domain2. They have got RUSER server role to access to RS
with Windows Auth.
When I open reports on Domain2 I could see Report Manager home page,
but when I click report I get "Internet Explorer cannot display the
webpage".
Is it possible to have access from 2 different domains to RS?
Any help appreciate.
Regards,
BartekAre the domains trusted? Does Domain1 trust Domain2?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> My RS was installed on server which is accessed from 2 domains (lets
> named Domain1 and Domain2).
> Server belongs to Domain1 and RS service has admin privileges on
> Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> have users in Domain2. They have got RUSER server role to access to RS
> with Windows Auth.
> When I open reports on Domain2 I could see Report Manager home page,
> but when I click report I get "Internet Explorer cannot display the
> webpage".
> Is it possible to have access from 2 different domains to RS?
> Any help appreciate.
> Regards,
> Bartek|||Yes, both domains are trusted.
Bartek
On 4 Kwi, 17:50, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Are the domains trusted? Does Domain1 trust Domain2?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bartolo" <andrew...@.gmail.com> wrote in message
> news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> > My RS was installed on server which is accessed from 2 domains (lets
> > named Domain1 and Domain2).
> > Server belongs to Domain1 and RS service has admin privileges on
> > Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> > have users in Domain2. They have got RUSER server role to access to RS
> > with Windows Auth.
> > When I open reports on Domain2 I could see Report Manager home page,
> > but when I click report I get "Internet Explorer cannot display the
> > webpage".
> > Is it possible to have access from 2 different domains to RS?
> > Any help appreciate.
> > Regards,
> > Bartek
named Domain1 and Domain2).
Server belongs to Domain1 and RS service has admin privileges on
Domain1 as well. Viewing reports on Domain1 cause no problem. But I
have users in Domain2. They have got RUSER server role to access to RS
with Windows Auth.
When I open reports on Domain2 I could see Report Manager home page,
but when I click report I get "Internet Explorer cannot display the
webpage".
Is it possible to have access from 2 different domains to RS?
Any help appreciate.
Regards,
BartekAre the domains trusted? Does Domain1 trust Domain2?
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Bartolo" <andrew.osa@.gmail.com> wrote in message
news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> My RS was installed on server which is accessed from 2 domains (lets
> named Domain1 and Domain2).
> Server belongs to Domain1 and RS service has admin privileges on
> Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> have users in Domain2. They have got RUSER server role to access to RS
> with Windows Auth.
> When I open reports on Domain2 I could see Report Manager home page,
> but when I click report I get "Internet Explorer cannot display the
> webpage".
> Is it possible to have access from 2 different domains to RS?
> Any help appreciate.
> Regards,
> Bartek|||Yes, both domains are trusted.
Bartek
On 4 Kwi, 17:50, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Are the domains trusted? Does Domain1 trust Domain2?
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Bartolo" <andrew...@.gmail.com> wrote in message
> news:44bafaf7-1f58-4387-9014-2bec3a3caaa5@.8g2000hsu.googlegroups.com...
> > My RS was installed on server which is accessed from 2 domains (lets
> > named Domain1 and Domain2).
> > Server belongs to Domain1 and RS service has admin privileges on
> > Domain1 as well. Viewing reports on Domain1 cause no problem. But I
> > have users in Domain2. They have got RUSER server role to access to RS
> > with Windows Auth.
> > When I open reports on Domain2 I could see Report Manager home page,
> > but when I click report I get "Internet Explorer cannot display the
> > webpage".
> > Is it possible to have access from 2 different domains to RS?
> > Any help appreciate.
> > Regards,
> > Bartek
Sunday, March 11, 2012
Cannot view DB properties
Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin rights
to view the DB properties and its failing with "Property Owner is not
available for Database '[DB_name]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
ThanksIT (IT@.discussions.microsoft.com) writes:
> Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
> rights to view the DB properties and its failing with "Property Owner is
> not available for Database '[DB_name]'. This property may not exist fo
r
> this object, or may not be retrievable due to insufficient access
> rights. (Microsoft.SqlServer.Smo)"
> I was able to view the properties of the same database using same domain
> user when we were in SQL 2000.
> How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I did In-Place Upgrade, I have like 20 databases and when I checked using
sp_helpdb for all databases, found NULL for 5 databases.
I followed the command
ALTER AUTHORIZATION ON DATABASE::database_name TO sa
Failed with:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database
.
Any other workarounds? Is this a Bug...in SQL 2005...
"Erland Sommarskog" wrote:
> IT (IT@.discussions.microsoft.com) writes:
> How did you upgrade? Did you upgrade the server in place, to did you
> reattach the database?
> It sounds as the latter. The SID for the database user, does not seem to
> match any login on the server. Use
> ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
> and if necessary, create a login for the domain user first.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||IT
Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
I just did testing and it worked fine.
1) BACKUP DATABASE command on SQL Server 2000
2) RESTORE DATABASE command on SQL Server 2005
3) Drop user in the database after restoring
4) CREATE LOGIN on SQL Server 2005
5) CREATE USER in the database and mapped it to the new created LOGIN
If it does not help, please privide with steps you did so far.
"IT" <IT@.discussions.microsoft.com> wrote in message
news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...[vbcol=seagreen]
>I did In-Place Upgrade, I have like 20 databases and when I checked using
> sp_helpdb for all databases, found NULL for 5 databases.
> I followed the command
> ALTER AUTHORIZATION ON DATABASE::database_name TO sa
> Failed with:
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
>
> Any other workarounds? Is this a Bug...in SQL 2005...
>
> "Erland Sommarskog" wrote:
>|||Here are the steps I followed:
# Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server
2005.
# I have like 20 databases and only for 5 databases I noticed that database
owner was NULL after the UPgraded finished successfully.
# I checked that by using sp_helpdb...IN the OWNER filed found NULL for
those 5 databases.
# Ran sp_changedbowner 'sa' and it updated the OWNER to SA
# If I want to change the owner to any existing user in the database it
gives me
following error.
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.
I can only change the Owner to sa and for any other USER if throws me the
error I mentioned above.My question here is , Even though I upgraded the
existing instance of 2000 to 2005, why is that only for 5 databases I am
seeing this kind of behaviour.
Every thing was fine when it was in sql 2000.I was able to change the DB
Owner...
Thanks
"Uri Dimant" wrote:
> IT
> Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
> I just did testing and it worked fine.
> 1) BACKUP DATABASE command on SQL Server 2000
> 2) RESTORE DATABASE command on SQL Server 2005
> 3) Drop user in the database after restoring
> 4) CREATE LOGIN on SQL Server 2005
> 5) CREATE USER in the database and mapped it to the new created LOGIN
>
> If it does not help, please privide with steps you did so far.
>
>
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...
>
>|||Sounds like a phantom user situation which is causing your error to be
thrown.
Check out http://sta.c64.org/sqlprg.html
And download http://sta.c64.org/sqlprg/fixusers.zip
Before you run the script be sure and read what it does.
Good luck to ya.
IT wrote:[vbcol=seagreen]
> Here are the steps I followed:
> # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Serve
r
> 2005.
> # I have like 20 databases and only for 5 databases I noticed that databas
e
> owner was NULL after the UPgraded finished successfully.
> # I checked that by using sp_helpdb...IN the OWNER filed found NULL for
> those 5 databases.
> # Ran sp_changedbowner 'sa' and it updated the OWNER to SA
> # If I want to change the owner to any existing user in the database it
> gives me
> following error.
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
> I can only change the Owner to sa and for any other USER if throws me the
> error I mentioned above.My question here is , Even though I upgraded the
> existing instance of 2000 to 2005, why is that only for 5 databases I am
> seeing this kind of behaviour.
> Every thing was fine when it was in sql 2000.I was able to change the DB
> Owner...
>
> Thanks
> "Uri Dimant" wrote:
>|||The users in the databases have respective logins on the server. There are n
o
orphaned users on the database. The issue is we cannot change the DB owner t
o
the existing users in the database except for SA.
"jebuskrust@.gmail.com" wrote:
> Sounds like a phantom user situation which is causing your error to be
> thrown.
> Check out http://sta.c64.org/sqlprg.html
> And download http://sta.c64.org/sqlprg/fixusers.zip
> Before you run the script be sure and read what it does.
> Good luck to ya.
>
> IT wrote:
>|||IT (IT@.discussions.microsoft.com) writes:
> The users in the databases have respective logins on the server. There
> are no orphaned users on the database. The issue is we cannot change the
> DB owner to the existing users in the database except for SA.
That is not possible on SQL 2000 either.
The login that owns the database always maps to the dbo user. If the login
already maps to a user in the database, the login can't become the database
owner, because he would then map to two users.
Thus you need to explicitly drop the users that you want to own the
databases.
I can't answer why you only got a problem with 5 of 20 databases. The
answer for that may be hidden in their previous history.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
to view the DB properties and its failing with "Property Owner is not
available for Database '[DB_name]'. This property may not exist for this
object, or may not be retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)"
I was able to view the properties of the same database using same domain
user when we were in SQL 2000.
How to solve this issue? Any input is appreciated..
ThanksIT (IT@.discussions.microsoft.com) writes:
> Upgraded from SQL 2000 to SQL 2005. I am using Domain User with admin
> rights to view the DB properties and its failing with "Property Owner is
> not available for Database '[DB_name]'. This property may not exist fo
r
> this object, or may not be retrievable due to insufficient access
> rights. (Microsoft.SqlServer.Smo)"
> I was able to view the properties of the same database using same domain
> user when we were in SQL 2000.
> How to solve this issue? Any input is appreciated..
How did you upgrade? Did you upgrade the server in place, to did you
reattach the database?
It sounds as the latter. The SID for the database user, does not seem to
match any login on the server. Use
ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
and if necessary, create a login for the domain user first.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I did In-Place Upgrade, I have like 20 databases and when I checked using
sp_helpdb for all databases, found NULL for 5 databases.
I followed the command
ALTER AUTHORIZATION ON DATABASE::database_name TO sa
Failed with:
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the database
.
Any other workarounds? Is this a Bug...in SQL 2005...
"Erland Sommarskog" wrote:
> IT (IT@.discussions.microsoft.com) writes:
> How did you upgrade? Did you upgrade the server in place, to did you
> reattach the database?
> It sounds as the latter. The SID for the database user, does not seem to
> match any login on the server. Use
> ALTER AUTHORIZATION ON DATABASE:db TO [domain\user]
> and if necessary, create a login for the domain user first.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx
>|||IT
Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
I just did testing and it worked fine.
1) BACKUP DATABASE command on SQL Server 2000
2) RESTORE DATABASE command on SQL Server 2005
3) Drop user in the database after restoring
4) CREATE LOGIN on SQL Server 2005
5) CREATE USER in the database and mapped it to the new created LOGIN
If it does not help, please privide with steps you did so far.
"IT" <IT@.discussions.microsoft.com> wrote in message
news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...[vbcol=seagreen]
>I did In-Place Upgrade, I have like 20 databases and when I checked using
> sp_helpdb for all databases, found NULL for 5 databases.
> I followed the command
> ALTER AUTHORIZATION ON DATABASE::database_name TO sa
> Failed with:
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
>
> Any other workarounds? Is this a Bug...in SQL 2005...
>
> "Erland Sommarskog" wrote:
>|||Here are the steps I followed:
# Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Server
2005.
# I have like 20 databases and only for 5 databases I noticed that database
owner was NULL after the UPgraded finished successfully.
# I checked that by using sp_helpdb...IN the OWNER filed found NULL for
those 5 databases.
# Ran sp_changedbowner 'sa' and it updated the OWNER to SA
# If I want to change the owner to any existing user in the database it
gives me
following error.
Msg 15110, Level 16, State 1, Line 1
The proposed new database owner is already a user or aliased in the
database.
I can only change the Owner to sa and for any other USER if throws me the
error I mentioned above.My question here is , Even though I upgraded the
existing instance of 2000 to 2005, why is that only for 5 databases I am
seeing this kind of behaviour.
Every thing was fine when it was in sql 2000.I was able to change the DB
Owner...
Thanks
"Uri Dimant" wrote:
> IT
> Sorry, I don't understand , what do you mean by "In-Place Upgrade"?
> I just did testing and it worked fine.
> 1) BACKUP DATABASE command on SQL Server 2000
> 2) RESTORE DATABASE command on SQL Server 2005
> 3) Drop user in the database after restoring
> 4) CREATE LOGIN on SQL Server 2005
> 5) CREATE USER in the database and mapped it to the new created LOGIN
>
> If it does not help, please privide with steps you did so far.
>
>
> "IT" <IT@.discussions.microsoft.com> wrote in message
> news:A8BF2B36-4223-49A6-948B-E5097FC52082@.microsoft.com...
>
>|||Sounds like a phantom user situation which is causing your error to be
thrown.
Check out http://sta.c64.org/sqlprg.html
And download http://sta.c64.org/sqlprg/fixusers.zip
Before you run the script be sure and read what it does.
Good luck to ya.
IT wrote:[vbcol=seagreen]
> Here are the steps I followed:
> # Ran the setup and upgraded the existing SQL Server 8.00.818 to SQL Serve
r
> 2005.
> # I have like 20 databases and only for 5 databases I noticed that databas
e
> owner was NULL after the UPgraded finished successfully.
> # I checked that by using sp_helpdb...IN the OWNER filed found NULL for
> those 5 databases.
> # Ran sp_changedbowner 'sa' and it updated the OWNER to SA
> # If I want to change the owner to any existing user in the database it
> gives me
> following error.
> Msg 15110, Level 16, State 1, Line 1
> The proposed new database owner is already a user or aliased in the
> database.
> I can only change the Owner to sa and for any other USER if throws me the
> error I mentioned above.My question here is , Even though I upgraded the
> existing instance of 2000 to 2005, why is that only for 5 databases I am
> seeing this kind of behaviour.
> Every thing was fine when it was in sql 2000.I was able to change the DB
> Owner...
>
> Thanks
> "Uri Dimant" wrote:
>|||The users in the databases have respective logins on the server. There are n
o
orphaned users on the database. The issue is we cannot change the DB owner t
o
the existing users in the database except for SA.
"jebuskrust@.gmail.com" wrote:
> Sounds like a phantom user situation which is causing your error to be
> thrown.
> Check out http://sta.c64.org/sqlprg.html
> And download http://sta.c64.org/sqlprg/fixusers.zip
> Before you run the script be sure and read what it does.
> Good luck to ya.
>
> IT wrote:
>|||IT (IT@.discussions.microsoft.com) writes:
> The users in the databases have respective logins on the server. There
> are no orphaned users on the database. The issue is we cannot change the
> DB owner to the existing users in the database except for SA.
That is not possible on SQL 2000 either.
The login that owns the database always maps to the dbo user. If the login
already maps to a user in the database, the login can't become the database
owner, because he would then map to two users.
Thus you need to explicitly drop the users that you want to own the
databases.
I can't answer why you only got a problem with 5 of 20 databases. The
answer for that may be hidden in their previous history.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx
Saturday, February 25, 2012
cannot start MSSQLServerOLAPService....error 1058: the service cannot be started
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
cannot start MSSQLServerOLAPService....error 1058: the service cannot be started
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
cannot start MSSQLServerOLAPService....error 1058: the service cannot be started
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.OS error 1058 means "The service cannot be started, either because it is
disabled or because it has no enabled devices associated with it".
So, from the services applet, have you made sure the service is not
disabled?
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"madman_miceli" <madman@.amiceli.com> wrote in message
news:eVQK11JmFHA.3312@.tk2msftngp13.phx.gbl...
sql 2000 w/ sp4 running on w2k3 using sql authenitcation......olap service
account is running under AD admin account and is a member of local OLAP
admin group.
not sure what else to check....have looked all over the net.
thanks.
Subscribe to:
Posts (Atom)