Error on install

I'm trying to install an instance of Reporting Services onto a 2003 Server.
Everything works great until I get to the part where I connect it to a
database. I'm attempting to connect it to a SQL 2005 server. I get an error
when it trys to "Create A Grants Rights Script." Here's the rest of the error:
System.Management.ManagementException: Access denied
at
System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
errorCode)
at System.Management.ManagementScope.InitializeGuts(Object o)
at System.Management.ManagementScope.Initialize()
at System.Management.ManagementObjectSearcher.Initialize()
at System.Management.ManagementObjectSearcher.Get()
at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String
machine)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
dbServer)
at
ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
connectionString, String server, String database,
ConfigurationCredentialsType credsType, String account, String password,
Boolean upgrade, String dbVersion)
Now. There should be no reson for me to get an access denied error on this
portion. I've tried it 2 different ways. First, I've tried using my windows
credentials. I'm the system dba with all the access, secondly, I've tried
creating a sql account will all the access I can possibly give it, and I
still get this error.
Any ideas anyone has would be great.
-- CaseyHi Casey,
I am having same problem, do you have any luck?
thanks.
SKip
"Casey" wrote:
> I'm trying to install an instance of Reporting Services onto a 2003 Server.
> Everything works great until I get to the part where I connect it to a
> database. I'm attempting to connect it to a SQL 2005 server. I get an error
> when it trys to "Create A Grants Rights Script." Here's the rest of the error:
> System.Management.ManagementException: Access denied
> at
> System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> errorCode)
> at System.Management.ManagementScope.InitializeGuts(Object o)
> at System.Management.ManagementScope.Initialize()
> at System.Management.ManagementObjectSearcher.Initialize()
> at System.Management.ManagementObjectSearcher.Get()
> at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String
> machine)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> dbServer)
> at
> ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> connectionString, String server, String database,
> ConfigurationCredentialsType credsType, String account, String password,
> Boolean upgrade, String dbVersion)
> Now. There should be no reson for me to get an access denied error on this
> portion. I've tried it 2 different ways. First, I've tried using my windows
> credentials. I'm the system dba with all the access, secondly, I've tried
> creating a sql account will all the access I can possibly give it, and I
> still get this error.
> Any ideas anyone has would be great.
> -- Casey|||Hi,
I am also having the same problem. Please anybody has an answer the this?
Thanks,
Henry
"Skip" wrote:
> Hi Casey,
> I am having same problem, do you have any luck?
> thanks.
> SKip
> "Casey" wrote:
> > I'm trying to install an instance of Reporting Services onto a 2003 Server.
> > Everything works great until I get to the part where I connect it to a
> > database. I'm attempting to connect it to a SQL 2005 server. I get an error
> > when it trys to "Create A Grants Rights Script." Here's the rest of the error:
> >
> > System.Management.ManagementException: Access denied
> > at
> > System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus
> > errorCode)
> > at System.Management.ManagementScope.InitializeGuts(Object o)
> > at System.Management.ManagementScope.Initialize()
> > at System.Management.ManagementObjectSearcher.Initialize()
> > at System.Management.ManagementObjectSearcher.Get()
> > at Microsoft.ReportingServices.Diagnostics.WebUtil.GetIPAddresses(String
> > machine)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.IsLocalDbServer(String
> > dbServer)
> > at
> > ReportServicesConfigUI.Panels.DatabaseSetupPanel.SetDatabaseConnectionTask(String
> > connectionString, String server, String database,
> > ConfigurationCredentialsType credsType, String account, String password,
> > Boolean upgrade, String dbVersion)
> >
> > Now. There should be no reson for me to get an access denied error on this
> > portion. I've tried it 2 different ways. First, I've tried using my windows
> > credentials. I'm the system dba with all the access, secondly, I've tried
> > creating a sql account will all the access I can possibly give it, and I
> > still get this error.
> >
> > Any ideas anyone has would be great.
> >
> > -- Casey

Error On deploy (F5) - Cannot connect to Server

I am learning SQL Server 2005 Analysis Services. I am following the following webcast

http://msevents.microsoft.com/cui/WebCastEventDetails.aspx?culture=en-US&EventID=1032263433&CountryCode=US

When I try to deploy the project (F5) in Business Intelligence studio, I get the error message 'cannot connect to the server, check project properties under deployment'. I have checked those properties and made sure that the server name is correct and I have created a database on the server too.

I have tried installing SP2. But I still get the error message.

Any ideas what I need to do to fix this?

Thank you,

jsmith

Is the server installed on the same machine that you are using Visual Studio on? If not, how are you accessing the server?|||

Yes it is installed on the same machine. I am using windows authentication to access it.

Thanks,

jsmith

|||

Some additional info: I cannot connect to the Analysis Services through Management Studio, too. Following is the detail of the error message:

===================================

Cannot connect to TESTSERVER.

===================================

A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices.AdomdClient)

Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.OpenTcpConnection(ConnectionInfo connectionInfo)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.Connect(ConnectionInfo connectionInfo, Boolean beginSession)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.ConnectXmla()
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

===================================

A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond (System)

Program Location:

at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.Net.Sockets.TcpClient.Connect(IPEndPoint remoteEP)
at System.Net.Sockets.TcpClient.Connect(IPAddress address, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClientByAddress(String hostName, Int32 port)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.GetTcpClient(ConnectionInfo connectionInfo)

Any ideas?

Thanks

jsmtih

|||Have you verified that the Analysis Server is up and running? Go to Services under Administrative tools and look for SQL Server Analysis Services (<name of your server>). It should be started.|||

Yes Analysis services are running under services. I also cannot connect to reporting services.

I am able to connect to Database services and Integration services.

Thanks,

|||Are you running under the account that installed SSAS or as a local administrator. If not you might need to get a local machine admin to logon, start up SSMS and add you to the server's security group.|||

Ok. There was a firewall on the computer which was blocking some ports and not allowing the connections to be made.

When a previous image was restored (before the firewall), everything started working fine.

Thank you so much everyone for trying to help

Regards,

jsmith.

Error Nuimber 913 - Could not find database ID

Michael,
- what interface are you using to connect to SQL Server from your applicatio
n?
- can you post the code where you set the connection properties?
AMB
"Michael MacGregor" wrote:

> An interesting error occurred today along with some inconsistent behaviour
.
> On our test database we have one database, that is the main one and in whi
ch
> all the SPs are located. Then we have a secondary database, the data in
> which is accessed only by stored procs run from the main database. Recentl
y
> we updated this secondary database by dropping the old one and recreating
> it. This changed, presumably, the db_id for that database, same name.
> Now when we tried to run any of the SPs that access this secondary databas
e,
> they caused error number 913, "Could not find database ID %d. Database may
> not be activated yet or may be in transition." Which seems logical if the
> secondary database now has a different db_id from the old one that was
> dropped. However, when the same SPs are executed in Query Analyzer, they r
un
> fine, no error, and they return data.
> Any idea what's going on? Why would execution of the SPs cause an error fr
om
> the application viewpoint but not in Query Analyzer?
> This really has me puzzled.
> TIA
> Michael MacGregor
> Database Architect
>
>An interesting error occurred today along with some inconsistent behaviour.
On our test database we have one database, that is the main one and in which
all the SPs are located. Then we have a secondary database, the data in
which is accessed only by stored procs run from the main database. Recently
we updated this secondary database by dropping the old one and recreating
it. This changed, presumably, the db_id for that database, same name.
Now when we tried to run any of the SPs that access this secondary database,
they caused error number 913, "Could not find database ID %d. Database may
not be activated yet or may be in transition." Which seems logical if the
secondary database now has a different db_id from the old one that was
dropped. However, when the same SPs are executed in Query Analyzer, they run
fine, no error, and they return data.
Any idea what's going on? Why would execution of the SPs cause an error from
the application viewpoint but not in Query Analyzer?
This really has me puzzled.
TIA
Michael MacGregor
Database Architect|||Michael,
- what interface are you using to connect to SQL Server from your applicatio
n?
- can you post the code where you set the connection properties?
AMB
"Michael MacGregor" wrote:

> An interesting error occurred today along with some inconsistent behaviour
.
> On our test database we have one database, that is the main one and in whi
ch
> all the SPs are located. Then we have a secondary database, the data in
> which is accessed only by stored procs run from the main database. Recentl
y
> we updated this secondary database by dropping the old one and recreating
> it. This changed, presumably, the db_id for that database, same name.
> Now when we tried to run any of the SPs that access this secondary databas
e,
> they caused error number 913, "Could not find database ID %d. Database may
> not be activated yet or may be in transition." Which seems logical if the
> secondary database now has a different db_id from the old one that was
> dropped. However, when the same SPs are executed in Query Analyzer, they r
un
> fine, no error, and they return data.
> Any idea what's going on? Why would execution of the SPs cause an error fr
om
> the application viewpoint but not in Query Analyzer?
> This really has me puzzled.
> TIA
> Michael MacGregor
> Database Architect
>
>|||This is what my Java guy gave me when I asked him for the information. Is
this what you wanted?
public static String strDbUser =
"<userID>";
public static String strDbPwd =
"<pwd>";
public static String strDefaultServer = "<sqlserver>";
A JDBC SQL server driver is being used as an interface between the Java app
and sql server.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:75FF2CB6-94CB-423B-A17F-EEE0688825A6@.microsoft.com...[vbcol=seagreen]
> Michael,
> - what interface are you using to connect to SQL Server from your
> application?
> - can you post the code where you set the connection properties?
>
> AMB
> "Michael MacGregor" wrote:
>|||Michael,
Seems like the connection is using the default database for that user. If
the default db was pointing to the the one you recreated, then the default d
b
for that user is pointing to the wrong db_id. You will have to change the
default db for your users, using sp_defaultdb.
AMB
"Michael MacGregor" wrote:

> This is what my Java guy gave me when I asked him for the information. Is
> this what you wanted?
> public static String strDbUser =
> "<userID>";
> public static String strDbPwd =
> "<pwd>";
> public static String strDefaultServer = "<sqlserver>";
> A JDBC SQL server driver is being used as an interface between the Java ap
p
> and sql server.
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:75FF2CB6-94CB-423B-A17F-EEE0688825A6@.microsoft.com...
>
>|||Forgot to mention that you can also specify the db to which you want to
connect in the connection properties. I am not familiar with JDBC but this
should be something comon in every interface.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Michael,
> Seems like the connection is using the default database for that user. If
> the default db was pointing to the the one you recreated, then the default
db
> for that user is pointing to the wrong db_id. You will have to change the
> default db for your users, using sp_defaultdb.
>
> AMB
>
> "Michael MacGregor" wrote:
>|||This is what my Java guy gave me when I asked him for the information. Is
this what you wanted?
public static String strDbUser =
"<userID>";
public static String strDbPwd =
"<pwd>";
public static String strDefaultServer = "<sqlserver>";
A JDBC SQL server driver is being used as an interface between the Java app
and sql server.
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:75FF2CB6-94CB-423B-A17F-EEE0688825A6@.microsoft.com...[vbcol=seagreen]
> Michael,
> - what interface are you using to connect to SQL Server from your
> application?
> - can you post the code where you set the connection properties?
>
> AMB
> "Michael MacGregor" wrote:
>|||Michael,
Seems like the connection is using the default database for that user. If
the default db was pointing to the the one you recreated, then the default d
b
for that user is pointing to the wrong db_id. You will have to change the
default db for your users, using sp_defaultdb.
AMB
"Michael MacGregor" wrote:

> This is what my Java guy gave me when I asked him for the information. Is
> this what you wanted?
> public static String strDbUser =
> "<userID>";
> public static String strDbPwd =
> "<pwd>";
> public static String strDefaultServer = "<sqlserver>";
> A JDBC SQL server driver is being used as an interface between the Java ap
p
> and sql server.
> "Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in messag
e
> news:75FF2CB6-94CB-423B-A17F-EEE0688825A6@.microsoft.com...
>
>|||Forgot to mention that you can also specify the db to which you want to
connect in the connection properties. I am not familiar with JDBC but this
should be something comon in every interface.
AMB
"Alejandro Mesa" wrote:
[vbcol=seagreen]
> Michael,
> Seems like the connection is using the default database for that user. If
> the default db was pointing to the the one you recreated, then the default
db
> for that user is pointing to the wrong db_id. You will have to change the
> default db for your users, using sp_defaultdb.
>
> AMB
>
> "Michael MacGregor" wrote:
>

error message

I finally installed MSDE and have the icon in my tray at the bottom of the screen.
When I try to connect to a database using the wizard in the web matrix program I get this message:
Unable to connect
SQL Server does not exist of access denied
Connection Open (Connect ())
What might be wrong??
Thanks for your help I'll get it soon (I hope)
Del Dobbswell, are you specifying the correct instance name? username? password?|||see this

http://support.microsoft.com/?kbid=328306