I have just installed Sql server 2005 on my Win XP Pro machine.
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Named Pipes Provider, error 40 - Could not open
a connection
to sql server.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
Laurence
I suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Named Pipes Provider, error 40 - Could not open a
> connection
> to sql server.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>
|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>
sql
Showing posts with label management. Show all posts
Showing posts with label management. Show all posts
Thursday, March 29, 2012
Can't Connect
I have just installed Sql server 2005 on my Win XP Pro machine.
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Named Pipes Provider, error 40 - Could not open
a connection
to sql server.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
LaurenceI suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Named Pipes Provider, error 40 - Could not open a
> connection
> to sql server.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>
When I go into the sql server management studio, there is only
one entry under the "database engine" entry in the registered servers'
panel on the left. It is MyServerName\SQLEXPRESS.
When I click on it and then select connect, either new query
or object explorer, I get one of the following errors.
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Sql Network interfaces, error: 26 - Error locating
Server/Instance Specified )
An error has occurred while establishing a connection to there server.
When connecting to SQL Server 2005, the failure may be caused by the
fact that under the default settings SQL Server does not allow remote
connections. (Provider : Named Pipes Provider, error 40 - Could not open
a connection
to sql server.
I have looked all over the internet, but couldn't find anything that
would help.
I went into the sql server configuration manger, and enabled the name
pipes and rebooted.
I didn't work. In the sql service configuration manager I have five
services that are status of
running and startup mode of automatic. However they are not for the
SQLExpress server.
They are for another sql server name, that I put in for the server name
when I installed
sql server 2005. I thought that would be the server name.
There are two entries under sql server 2005 network configuration
Protocals for SQLEXPRESS and
Protocals for Myotherservername
How can I connect.
Why do I have two instances are those instances of servers,
I thought that there was only server.
What do I do?
Thanks in Advance,
LaurenceI suggest starting with my blog entry on connecting. Just search
www.betav.com/blog/billva. There are several relevant articles there.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Larry" <NoSpam@.Something.com> wrote in message
news:e5O9nLU3HHA.5316@.TK2MSFTNGP04.phx.gbl...
>I have just installed Sql server 2005 on my Win XP Pro machine.
> When I go into the sql server management studio, there is only
> one entry under the "database engine" entry in the registered servers'
> panel on the left. It is MyServerName\SQLEXPRESS.
> When I click on it and then select connect, either new query
> or object explorer, I get one of the following errors.
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Sql Network interfaces, error: 26 - Error
> locating
> Server/Instance Specified )
> An error has occurred while establishing a connection to there server.
> When connecting to SQL Server 2005, the failure may be caused by the
> fact that under the default settings SQL Server does not allow remote
> connections. (Provider : Named Pipes Provider, error 40 - Could not open a
> connection
> to sql server.
> I have looked all over the internet, but couldn't find anything that would
> help.
> I went into the sql server configuration manger, and enabled the name
> pipes and rebooted.
> I didn't work. In the sql service configuration manager I have five
> services that are status of
> running and startup mode of automatic. However they are not for the
> SQLExpress server.
> They are for another sql server name, that I put in for the server name
> when I installed
> sql server 2005. I thought that would be the server name.
> There are two entries under sql server 2005 network configuration
> Protocals for SQLEXPRESS and
> Protocals for Myotherservername
>
> How can I connect.
> Why do I have two instances are those instances of servers,
> I thought that there was only server.
> What do I do?
> Thanks in Advance,
> Laurence
>
>
>
>|||Thank You.
William Vaughn wrote:
> I suggest starting with my blog entry on connecting. Just search
> www.betav.com/blog/billva. There are several relevant articles there.
>
Cant Connect
I have installed SQL 2005 and just done a normal install. I have opened
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
ChrisFIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co.uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it...
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your senten
ce.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it...
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> 2) ODBC driver
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then
> you create an MDB and link tables from the ODBC source you defined.
> Yet, you are not able to exploit stored procedures, views, functions,
> and so on.
I forgot to say that using ODBC driver you cannot see relationships too.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.
4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
>|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it...
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>sql
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
ChrisFIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co.uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co.uk...
>|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it...
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your senten
ce.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it...
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>|||> 2) ODBC driver
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then
> you create an MDB and link tables from the ODBC source you defined.
> Yet, you are not able to exploit stored procedures, views, functions,
> and so on.
I forgot to say that using ODBC driver you cannot see relationships too.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.
4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
>|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it...
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>sql
Cant Connect
I have installed SQL 2005 and just done a normal install. I have opened
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
Chris
FIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>
|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co. uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>
|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it. ..
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your sentence.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it. ..
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||ADP is an Access Data Project - an Access front end that
uses SQL Server as the backend and doesn't involve Jet or
mdb files. You can find more information on this in the
Access help files - look for Access Project topics.
-Sue
On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
<chrisflyer@.blueyonder.co.uk> wrote:
>Can you explain what you mean by
>"The other one is to create an ADP and use OLE DB provider."
>I dont know what it is, also, would it be better to do it your way or my
>way?
>Thanks
>Chris
>"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
>news:875ea355bc088c813301ae47a36@.news.virgilio.it ...
>
|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it. ..
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
Server Management Studio and try and connect but I get the error;
...this failure may be caused buy the face that under the default settings
SQL server does not allow remote connections (provider: TCP Provider, error:
0 - No connection could be made because the target machine actively refused
it) (Microsoft SQL Server, error 10061)
Now this error only happens when connecting to the DB engine, it works fine
connecting to analysis services. I have chosen Windows Auth and also
specifying my sql account with the password with is a member of the SQL
groups in the users container but still doesn't work. I am logged in as
Administrator but I get this error.
I have installed SQL before and it worked fine, then it messed up so I
installed SQLExpress now I installed 2005 beta again to play some more and
its done this.
I am using server 2003 SP1
Thanks for your help
Chris
FIXED :D
I just needed to manually create the MSSQL ODBC connector and its fine
learn something new everyday
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>I have installed SQL 2005 and just done a normal install. I have opened
>Server Management Studio and try and connect but I get the error;
> ...this failure may be caused buy the face that under the default settings
> SQL server does not allow remote connections (provider: TCP Provider,
> error: 0 - No connection could be made because the target machine actively
> refused it) (Microsoft SQL Server, error 10061)
> Now this error only happens when connecting to the DB engine, it works
> fine connecting to analysis services. I have chosen Windows Auth and also
> specifying my sql account with the password with is a member of the SQL
> groups in the users container but still doesn't work. I am logged in as
> Administrator but I get this error.
> I have installed SQL before and it worked fine, then it messed up so I
> installed SQLExpress now I installed 2005 beta again to play some more and
> its done this.
> I am using server 2003 SP1
> Thanks for your help
> Chris
>
|||Going on from this however, if i wanted a desktop machine to connect, say,
Microsoft Access to my SQL database, do i need to create a MSSQL client
connection in the desktop ODBC?
Thanks
Chris
"kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
news:zsjQf.138255$DM.65219@.fe3.news.blueyonder.co. uk...
> FIXED :D
> I just needed to manually create the MSSQL ODBC connector and its fine
> learn something new everyday
> "kicken18" <chrisflyer@.blueyonder.co.uk> wrote in message
> news:ytiQf.138242$DM.34380@.fe3.news.blueyonder.co. uk...
>
|||> Going on from this however, if i wanted a desktop machine to connect,
> say, Microsoft Access to my SQL database, do i need to create a MSSQL
> client connection in the desktop ODBC?
This is one of two possible choices.
The other one is to create an ADP and use OLE DB provider.
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||sorry to sound dumb, but could you dumb that down a bit please lol
thanks
chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bbff8c8132b72f2d7d6@.news.virgilio.it. ..
> This is one of two possible choices.
> The other one is to create an ADP and use OLE DB provider.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||> sorry to sound dumb, but could you dumb that down a bit please lol
Sorry for my poor english, but I was not able to welle translate your sentence.
May you explain better, please?
PBsoft di Gabriele Bertolucci
www.pbsoft.it
skype: pbsoftsolution
|||Can you explain what you mean by
"The other one is to create an ADP and use OLE DB provider."
I dont know what it is, also, would it be better to do it your way or my
way?
Thanks
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc088c813301ae47a36@.news.virgilio.it. ..
> Sorry for my poor english, but I was not able to welle translate your
> sentence. May you explain better, please?
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
|||ADP is an Access Data Project - an Access front end that
uses SQL Server as the backend and doesn't involve Jet or
mdb files. You can find more information on this in the
Access help files - look for Access Project topics.
-Sue
On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
<chrisflyer@.blueyonder.co.uk> wrote:
>Can you explain what you mean by
>"The other one is to create an ADP and use OLE DB provider."
>I dont know what it is, also, would it be better to do it your way or my
>way?
>Thanks
>Chris
>"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
>news:875ea355bc088c813301ae47a36@.news.virgilio.it ...
>
|||Ah yes I do remember now, I think I have tried to use these befor.
Thanks for your assistance
Chris
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:hr2612lvbhhr1teiojvhb7aba44nb3huoe@.4ax.com...
> ADP is an Access Data Project - an Access front end that
> uses SQL Server as the backend and doesn't involve Jet or
> mdb files. You can find more information on this in the
> Access help files - look for Access Project topics.
> -Sue
> On Sat, 11 Mar 2006 15:16:14 GMT, "kicken18"
> <chrisflyer@.blueyonder.co.uk> wrote:
>
|||Thank you for the good help there, I can now go and test this.
Thank you for your time
Chris
"Gabriele Bertolucci" <info@.REMOVEpbsoft.it> wrote in message
news:875ea355bc418c813581ba41986@.news.virgilio.it. ..
> From Access you have two possibilities to use a MS SQL database.
> 1) OLE DB provider
> 2) ODBC driver
> 1) this is the best choice, in conjuntion to an Access Data Project.
> Microsoft created ADPs in order to interface SQL Server databases by
> Access via OLE DB provider and Jet Data Provider. ADPs connect to a SQL
> instance and let you see tables, stored procedures, views, functions, and
> so on.
> 2) this method lets you use Access as simply as with any other MDB.
> Indeed, you have to define a system DSN in Windows Data Source, then you
> create an MDB and link tables from the ODBC source you defined. Yet, you
> are not able to exploit stored procedures, views, functions, and so on.
> I suggest you to use the first method.
> Bye.
> --
> PBsoft di Gabriele Bertolucci
> www.pbsoft.it
> skype: pbsoftsolution
>
Tuesday, March 27, 2012
Can't check "Check existing data on creation" in relationship
Hi
When I added relationship to table, checked "Check existing data on
creation" and clicked "Save" in Enterprise Management tool, it has no error.
However, when I check tables again, the "Check existing data on creation"
option was unchecked.
Help me!It's the expected behaviour: the first time you create the
relationship, the existing data is verified (if "Check existing data on
creation" is checked) and subsequently all the new data is verified (if
"Enforce relationship for INSERTs and UPDATEs" is checked).
If you modify something in the relationship (for example: the
relationship's name or the cascade updates/deletes checkboxes), the
existing data does not need be verified again (that's why this checkbox
is unchecked when you look at it later).
Only if you modify the relationship in more semnificative ways (for
example: different columns), you should make sure that you click on
"Check existing data on creation" so the existing data will be verified
according to the new relationship.
Razvan
When I added relationship to table, checked "Check existing data on
creation" and clicked "Save" in Enterprise Management tool, it has no error.
However, when I check tables again, the "Check existing data on creation"
option was unchecked.
Help me!It's the expected behaviour: the first time you create the
relationship, the existing data is verified (if "Check existing data on
creation" is checked) and subsequently all the new data is verified (if
"Enforce relationship for INSERTs and UPDATEs" is checked).
If you modify something in the relationship (for example: the
relationship's name or the cascade updates/deletes checkboxes), the
existing data does not need be verified again (that's why this checkbox
is unchecked when you look at it later).
Only if you modify the relationship in more semnificative ways (for
example: different columns), you should make sure that you click on
"Check existing data on creation" so the existing data will be verified
according to the new relationship.
Razvan
Sunday, March 25, 2012
Can't Attach Database using SQL Server Management Studio Express
I am having a problem Attaching, well actually not being able to see a database when attempting to attach it. I suspect this is more of a security issue rather than a problem with Management Studio, but I can't figure out what is happening.
If I copy a database to Documents and Settings\All Users\... and attempt to attach I can see the file in the selection tree. This also is the case if I copy it to Documents and Settings\Default User\... But if I copy it to Documents and Settings\ADynarski\... which is the account I normally log into, when I expand the folder in the selection tree, nothing is visible. And the same thing occurs if I copy the file to Documents and Settings\Guest\...
I've looked at the security settings and everything appears to be normal. This is on a box with XP Home and SQL Server Express. Can anyone tell me what I'm missing?
Thanks,
Al
What is the account your SQL Server service running under?
If it's domain account, make sure the account has access to the folder you are trying attach database from.
|||Thanks for your input. It is a domain account and the account does have access to the folder. What is really strange is that I used Visual Web Developer Express to create the database in C:\Documents and Settings\Al Dynarski\My Documents\... and it functions properly. But logged into the same account, Server Management Studio sees nothing in the folder C:\Documents and Settings\Al Dynarski or below. I can copy the database out to another folder and then use Server Manangement Studio to work on it. Very strange. I'll continue to look around. Thanks again.|||Why are you copying the database files to a user folder rather than a common system folder ? If you want to attach the database files not via the userinstance feature, the SQL Server Service need to have access to the specified file for the database, so make sure that the service the SQL Server Account is running on, has access to this file destination.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks for your suggestion. I don't want to have to copy it; I only tried that to be sure it was in fact a valid database. And I agree with your assessment about SQL service having access rights to the folder containing the database. My problem appears to be figuring out why it doesn't
Thanks again.|||I got it working. I switched SQL Server Express to Local System Login and I now can see the database files and attach them. Since this server instance is just for my local testing, this configuration should work for me. Thanks to all for your suggestions.
Al
|||Hi Al,
I am having the same problem.... how do you switch SQL Server Express to Local System Login, and in doing so what else does this affect?
Thanks,
Claude.
|||Go to the SCM (Service Control Manager) of Windows, sleect the service you want to change the logon settings for, right click properties, go to the LogOn Tab and change the account to "Local System". Keep in min d that the service needs a restart after changing the settings.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Hi Claude,
The solution Jens indicated is exactly what I did.
Good Luck!
Al
Tuesday, March 20, 2012
Can't access Reporting with Management Studio
Bonjour!
I can't have access with my management studio to Reporting services
(2005)installed on my web server. (Cannot connect to...)Do my developpers
needs special rights?
Regards, Joel :)What do you mean access? You should be able to design reports without any
access to RS. It is only when deploying that you need special rights. Either
they need to be part of the local administrators group on the server where
RS is running OR they need to be put into the appropriate role (read up on
roles for Reporting Services).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> Bonjour!
> I can't have access with my management studio to Reporting services
> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> needs special rights?
> Regards, Joel :)|||Did you check SQL Server Configuration Manager to see if the Reporting
Services service is started? It could also be a rights issue. Do you have
sysadmin rights on your MSSQL server?
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> Bonjour!
> I can't have access with my management studio to Reporting services
> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> needs special rights?
> Regards, Joel :)|||Whoa! To deploy a report to RS does not need sysadmin rights. There is no
way that developers should have sysadmin rights on SQL server. RS does
everything based on its roles.
The local administrators role on the server (server not SQL Server)
automatically puts all users in that role with the rights to do anything
(subscriptions, deploy reports etc) to Reporting Services. However,
individual users or groups can be added to roles.
In Report Manager, be at Home. Click on the Properties tab, Click New Role
Assignments. Try Content Manager or Publisher. One of those roles will work.
All other folders inherit from home.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> Did you check SQL Server Configuration Manager to see if the Reporting
> Services service is started? It could also be a rights issue. Do you have
> sysadmin rights on your MSSQL server?
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> Bonjour!
>> I can't have access with my management studio to Reporting services
>> (2005)installed on my web server. (Cannot connect to...)Do my developpers
>> needs special rights?
>> Regards, Joel :)
>|||Thanks Guys, when we are with the browser on Reports Server, they can deploy
and access it, I made a special role for them, but with management studio we
cannot connect to it at all.
Joel:)
"Bruce L-C [MVP]" wrote:
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> way that developers should have sysadmin rights on SQL server. RS does
> everything based on its roles.
> The local administrators role on the server (server not SQL Server)
> automatically puts all users in that role with the rights to do anything
> (subscriptions, deploy reports etc) to Reporting Services. However,
> individual users or groups can be added to roles.
> In Report Manager, be at Home. Click on the Properties tab, Click New Role
> Assignments. Try Content Manager or Publisher. One of those roles will work.
> All other folders inherit from home.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> > Did you check SQL Server Configuration Manager to see if the Reporting
> > Services service is started? It could also be a rights issue. Do you have
> > sysadmin rights on your MSSQL server?
> >
> > --
> >
> > Alain Quesnel
> > alainsansspam@.logiquel.com
> >
> > www.logiquel.com
> >
> >
> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> Bonjour!
> >>
> >> I can't have access with my management studio to Reporting services
> >> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> >> needs special rights?
> >>
> >> Regards, Joel :)
> >
>
>|||Have you specified the path to deploy to? Right mouse click on the project
in BI Studio/VS. You need to set the target server URL to something like
this:
http://yourserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> Thanks Guys, when we are with the browser on Reports Server, they can
> deploy
> and access it, I made a special role for them, but with management studio
> we
> cannot connect to it at all.
> Joel:)
> "Bruce L-C [MVP]" wrote:
>> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
>> way that developers should have sysadmin rights on SQL server. RS does
>> everything based on its roles.
>> The local administrators role on the server (server not SQL Server)
>> automatically puts all users in that role with the rights to do anything
>> (subscriptions, deploy reports etc) to Reporting Services. However,
>> individual users or groups can be added to roles.
>> In Report Manager, be at Home. Click on the Properties tab, Click New
>> Role
>> Assignments. Try Content Manager or Publisher. One of those roles will
>> work.
>> All other folders inherit from home.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> > Did you check SQL Server Configuration Manager to see if the Reporting
>> > Services service is started? It could also be a rights issue. Do you
>> > have
>> > sysadmin rights on your MSSQL server?
>> >
>> > --
>> >
>> > Alain Quesnel
>> > alainsansspam@.logiquel.com
>> >
>> > www.logiquel.com
>> >
>> >
>> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> >> Bonjour!
>> >>
>> >> I can't have access with my management studio to Reporting services
>> >> (2005)installed on my web server. (Cannot connect to...)Do my
>> >> developpers
>> >> needs special rights?
>> >>
>> >> Regards, Joel :)
>> >
>>|||Yes that's what I do. My little issue here is not in Visual Studio, it is
when I try to connect to report server with MS SQL Server management studio,
on my test server that I have, everything on one box, it is connecting but
with my prod it doesn't. My prod is different, the Reporting is installed on
a web server with the database on another server.
Regards, Joel :)
"Bruce L-C [MVP]" wrote:
> Have you specified the path to deploy to? Right mouse click on the project
> in BI Studio/VS. You need to set the target server URL to something like
> this:
> http://yourserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> > Thanks Guys, when we are with the browser on Reports Server, they can
> > deploy
> > and access it, I made a special role for them, but with management studio
> > we
> > cannot connect to it at all.
> >
> > Joel:)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> >> way that developers should have sysadmin rights on SQL server. RS does
> >> everything based on its roles.
> >>
> >> The local administrators role on the server (server not SQL Server)
> >> automatically puts all users in that role with the rights to do anything
> >> (subscriptions, deploy reports etc) to Reporting Services. However,
> >> individual users or groups can be added to roles.
> >>
> >> In Report Manager, be at Home. Click on the Properties tab, Click New
> >> Role
> >> Assignments. Try Content Manager or Publisher. One of those roles will
> >> work.
> >>
> >> All other folders inherit from home.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> > Did you check SQL Server Configuration Manager to see if the Reporting
> >> > Services service is started? It could also be a rights issue. Do you
> >> > have
> >> > sysadmin rights on your MSSQL server?
> >> >
> >> > --
> >> >
> >> > Alain Quesnel
> >> > alainsansspam@.logiquel.com
> >> >
> >> > www.logiquel.com
> >> >
> >> >
> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> >> Bonjour!
> >> >>
> >> >> I can't have access with my management studio to Reporting services
> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> >> developpers
> >> >> needs special rights?
> >> >>
> >> >> Regards, Joel :)
> >> >
> >>
> >>
> >>
>
>|||I'm sorry. You asked about the developers so I immediately thought the issue
was not being able to deploy. Hence the thrust of all my posts. I never use
Management studio for anything with RS. I pulled it up just to see what it
offers and it does very little. It shows you some things but Report Manager
can easily do everything and more than what you can do with Management
Studio.
The other poster mentioned sysadmin rights on SQL Server. I don't think this
is necessary because when I look at what information is provided and changes
allowed, it is all straight Reporting Services. If you want developers to be
doing this (adding roles for instance) then have them either be in the local
administrators account on the server that is hosting Reporting Services or
add their account to the System Administrator role.
I suggest first making sure the developers can do what they need to do with
Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@.microsoft.com...
> Yes that's what I do. My little issue here is not in Visual Studio, it is
> when I try to connect to report server with MS SQL Server management
> studio,
> on my test server that I have, everything on one box, it is connecting but
> with my prod it doesn't. My prod is different, the Reporting is installed
> on
> a web server with the database on another server.
> Regards, Joel :)
> "Bruce L-C [MVP]" wrote:
>> Have you specified the path to deploy to? Right mouse click on the
>> project
>> in BI Studio/VS. You need to set the target server URL to something like
>> this:
>> http://yourserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
>> > Thanks Guys, when we are with the browser on Reports Server, they can
>> > deploy
>> > and access it, I made a special role for them, but with management
>> > studio
>> > we
>> > cannot connect to it at all.
>> >
>> > Joel:)
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is
>> >> no
>> >> way that developers should have sysadmin rights on SQL server. RS does
>> >> everything based on its roles.
>> >>
>> >> The local administrators role on the server (server not SQL Server)
>> >> automatically puts all users in that role with the rights to do
>> >> anything
>> >> (subscriptions, deploy reports etc) to Reporting Services. However,
>> >> individual users or groups can be added to roles.
>> >>
>> >> In Report Manager, be at Home. Click on the Properties tab, Click New
>> >> Role
>> >> Assignments. Try Content Manager or Publisher. One of those roles will
>> >> work.
>> >>
>> >> All other folders inherit from home.
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> >> > Did you check SQL Server Configuration Manager to see if the
>> >> > Reporting
>> >> > Services service is started? It could also be a rights issue. Do you
>> >> > have
>> >> > sysadmin rights on your MSSQL server?
>> >> >
>> >> > --
>> >> >
>> >> > Alain Quesnel
>> >> > alainsansspam@.logiquel.com
>> >> >
>> >> > www.logiquel.com
>> >> >
>> >> >
>> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> >> >> Bonjour!
>> >> >>
>> >> >> I can't have access with my management studio to Reporting services
>> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
>> >> >> developpers
>> >> >> needs special rights?
>> >> >>
>> >> >> Regards, Joel :)
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks, that's what I will do.
Regards, Joel :)
"Bruce L-C [MVP]" wrote:
> I'm sorry. You asked about the developers so I immediately thought the issue
> was not being able to deploy. Hence the thrust of all my posts. I never use
> Management studio for anything with RS. I pulled it up just to see what it
> offers and it does very little. It shows you some things but Report Manager
> can easily do everything and more than what you can do with Management
> Studio.
> The other poster mentioned sysadmin rights on SQL Server. I don't think this
> is necessary because when I look at what information is provided and changes
> allowed, it is all straight Reporting Services. If you want developers to be
> doing this (adding roles for instance) then have them either be in the local
> administrators account on the server that is hosting Reporting Services or
> add their account to the System Administrator role.
> I suggest first making sure the developers can do what they need to do with
> Report Manager.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@.microsoft.com...
> > Yes that's what I do. My little issue here is not in Visual Studio, it is
> > when I try to connect to report server with MS SQL Server management
> > studio,
> > on my test server that I have, everything on one box, it is connecting but
> > with my prod it doesn't. My prod is different, the Reporting is installed
> > on
> > a web server with the database on another server.
> >
> > Regards, Joel :)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Have you specified the path to deploy to? Right mouse click on the
> >> project
> >> in BI Studio/VS. You need to set the target server URL to something like
> >> this:
> >> http://yourserver/ReportServer
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> >> > Thanks Guys, when we are with the browser on Reports Server, they can
> >> > deploy
> >> > and access it, I made a special role for them, but with management
> >> > studio
> >> > we
> >> > cannot connect to it at all.
> >> >
> >> > Joel:)
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is
> >> >> no
> >> >> way that developers should have sysadmin rights on SQL server. RS does
> >> >> everything based on its roles.
> >> >>
> >> >> The local administrators role on the server (server not SQL Server)
> >> >> automatically puts all users in that role with the rights to do
> >> >> anything
> >> >> (subscriptions, deploy reports etc) to Reporting Services. However,
> >> >> individual users or groups can be added to roles.
> >> >>
> >> >> In Report Manager, be at Home. Click on the Properties tab, Click New
> >> >> Role
> >> >> Assignments. Try Content Manager or Publisher. One of those roles will
> >> >> work.
> >> >>
> >> >> All other folders inherit from home.
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> >> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> >> > Did you check SQL Server Configuration Manager to see if the
> >> >> > Reporting
> >> >> > Services service is started? It could also be a rights issue. Do you
> >> >> > have
> >> >> > sysadmin rights on your MSSQL server?
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Alain Quesnel
> >> >> > alainsansspam@.logiquel.com
> >> >> >
> >> >> > www.logiquel.com
> >> >> >
> >> >> >
> >> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> >> >> Bonjour!
> >> >> >>
> >> >> >> I can't have access with my management studio to Reporting services
> >> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> >> >> developpers
> >> >> >> needs special rights?
> >> >> >>
> >> >> >> Regards, Joel :)
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I agree that developers shoudn't have sa rights. I just wanted to know if he
could access SSRS through Management Studio with such rights. I've had a
similar issue that had to do with renaming a machine that hosts SSRS. I
still can't make the SSRS webserver work with a new machine name.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O1BeNPKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> way that developers should have sysadmin rights on SQL server. RS does
> everything based on its roles.
> The local administrators role on the server (server not SQL Server)
> automatically puts all users in that role with the rights to do anything
> (subscriptions, deploy reports etc) to Reporting Services. However,
> individual users or groups can be added to roles.
> In Report Manager, be at Home. Click on the Properties tab, Click New Role
> Assignments. Try Content Manager or Publisher. One of those roles will
> work.
> All other folders inherit from home.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> Did you check SQL Server Configuration Manager to see if the Reporting
>> Services service is started? It could also be a rights issue. Do you have
>> sysadmin rights on your MSSQL server?
>> --
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> Bonjour!
>> I can't have access with my management studio to Reporting services
>> (2005)installed on my web server. (Cannot connect to...)Do my
>> developpers
>> needs special rights?
>> Regards, Joel :)
>|||Accessing Reporting Services through SQL Server Management Studio DOES have
some good uses.
Mainly, you can organise reports much easier than in Report Manager, you can
also create the rdl from the report.
Having said that, I live with out it because I nearly always hit connection
problems on different sites and I'm not sure of the correct way to set it up.
Anyone got an idiots guide to setting the security up so that this facility
can be done. I have full administrator rights.
Thanks
Chris McGuigan
"Alain Quesnel" wrote:
> I agree that developers shoudn't have sa rights. I just wanted to know if he
> could access SSRS through Management Studio with such rights. I've had a
> similar issue that had to do with renaming a machine that hosts SSRS. I
> still can't make the SSRS webserver work with a new machine name.
>
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O1BeNPKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> > Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> > way that developers should have sysadmin rights on SQL server. RS does
> > everything based on its roles.
> >
> > The local administrators role on the server (server not SQL Server)
> > automatically puts all users in that role with the rights to do anything
> > (subscriptions, deploy reports etc) to Reporting Services. However,
> > individual users or groups can be added to roles.
> >
> > In Report Manager, be at Home. Click on the Properties tab, Click New Role
> > Assignments. Try Content Manager or Publisher. One of those roles will
> > work.
> >
> > All other folders inherit from home.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> > news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> Did you check SQL Server Configuration Manager to see if the Reporting
> >> Services service is started? It could also be a rights issue. Do you have
> >> sysadmin rights on your MSSQL server?
> >>
> >> --
> >>
> >> Alain Quesnel
> >> alainsansspam@.logiquel.com
> >>
> >> www.logiquel.com
> >>
> >>
> >> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> Bonjour!
> >>
> >> I can't have access with my management studio to Reporting services
> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> developpers
> >> needs special rights?
> >>
> >> Regards, Joel :)
> >>
> >
> >
>sql
I can't have access with my management studio to Reporting services
(2005)installed on my web server. (Cannot connect to...)Do my developpers
needs special rights?
Regards, Joel :)What do you mean access? You should be able to design reports without any
access to RS. It is only when deploying that you need special rights. Either
they need to be part of the local administrators group on the server where
RS is running OR they need to be put into the appropriate role (read up on
roles for Reporting Services).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> Bonjour!
> I can't have access with my management studio to Reporting services
> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> needs special rights?
> Regards, Joel :)|||Did you check SQL Server Configuration Manager to see if the Reporting
Services service is started? It could also be a rights issue. Do you have
sysadmin rights on your MSSQL server?
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> Bonjour!
> I can't have access with my management studio to Reporting services
> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> needs special rights?
> Regards, Joel :)|||Whoa! To deploy a report to RS does not need sysadmin rights. There is no
way that developers should have sysadmin rights on SQL server. RS does
everything based on its roles.
The local administrators role on the server (server not SQL Server)
automatically puts all users in that role with the rights to do anything
(subscriptions, deploy reports etc) to Reporting Services. However,
individual users or groups can be added to roles.
In Report Manager, be at Home. Click on the Properties tab, Click New Role
Assignments. Try Content Manager or Publisher. One of those roles will work.
All other folders inherit from home.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> Did you check SQL Server Configuration Manager to see if the Reporting
> Services service is started? It could also be a rights issue. Do you have
> sysadmin rights on your MSSQL server?
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> Bonjour!
>> I can't have access with my management studio to Reporting services
>> (2005)installed on my web server. (Cannot connect to...)Do my developpers
>> needs special rights?
>> Regards, Joel :)
>|||Thanks Guys, when we are with the browser on Reports Server, they can deploy
and access it, I made a special role for them, but with management studio we
cannot connect to it at all.
Joel:)
"Bruce L-C [MVP]" wrote:
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> way that developers should have sysadmin rights on SQL server. RS does
> everything based on its roles.
> The local administrators role on the server (server not SQL Server)
> automatically puts all users in that role with the rights to do anything
> (subscriptions, deploy reports etc) to Reporting Services. However,
> individual users or groups can be added to roles.
> In Report Manager, be at Home. Click on the Properties tab, Click New Role
> Assignments. Try Content Manager or Publisher. One of those roles will work.
> All other folders inherit from home.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> > Did you check SQL Server Configuration Manager to see if the Reporting
> > Services service is started? It could also be a rights issue. Do you have
> > sysadmin rights on your MSSQL server?
> >
> > --
> >
> > Alain Quesnel
> > alainsansspam@.logiquel.com
> >
> > www.logiquel.com
> >
> >
> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> Bonjour!
> >>
> >> I can't have access with my management studio to Reporting services
> >> (2005)installed on my web server. (Cannot connect to...)Do my developpers
> >> needs special rights?
> >>
> >> Regards, Joel :)
> >
>
>|||Have you specified the path to deploy to? Right mouse click on the project
in BI Studio/VS. You need to set the target server URL to something like
this:
http://yourserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> Thanks Guys, when we are with the browser on Reports Server, they can
> deploy
> and access it, I made a special role for them, but with management studio
> we
> cannot connect to it at all.
> Joel:)
> "Bruce L-C [MVP]" wrote:
>> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
>> way that developers should have sysadmin rights on SQL server. RS does
>> everything based on its roles.
>> The local administrators role on the server (server not SQL Server)
>> automatically puts all users in that role with the rights to do anything
>> (subscriptions, deploy reports etc) to Reporting Services. However,
>> individual users or groups can be added to roles.
>> In Report Manager, be at Home. Click on the Properties tab, Click New
>> Role
>> Assignments. Try Content Manager or Publisher. One of those roles will
>> work.
>> All other folders inherit from home.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> > Did you check SQL Server Configuration Manager to see if the Reporting
>> > Services service is started? It could also be a rights issue. Do you
>> > have
>> > sysadmin rights on your MSSQL server?
>> >
>> > --
>> >
>> > Alain Quesnel
>> > alainsansspam@.logiquel.com
>> >
>> > www.logiquel.com
>> >
>> >
>> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> >> Bonjour!
>> >>
>> >> I can't have access with my management studio to Reporting services
>> >> (2005)installed on my web server. (Cannot connect to...)Do my
>> >> developpers
>> >> needs special rights?
>> >>
>> >> Regards, Joel :)
>> >
>>|||Yes that's what I do. My little issue here is not in Visual Studio, it is
when I try to connect to report server with MS SQL Server management studio,
on my test server that I have, everything on one box, it is connecting but
with my prod it doesn't. My prod is different, the Reporting is installed on
a web server with the database on another server.
Regards, Joel :)
"Bruce L-C [MVP]" wrote:
> Have you specified the path to deploy to? Right mouse click on the project
> in BI Studio/VS. You need to set the target server URL to something like
> this:
> http://yourserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> > Thanks Guys, when we are with the browser on Reports Server, they can
> > deploy
> > and access it, I made a special role for them, but with management studio
> > we
> > cannot connect to it at all.
> >
> > Joel:)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> >> way that developers should have sysadmin rights on SQL server. RS does
> >> everything based on its roles.
> >>
> >> The local administrators role on the server (server not SQL Server)
> >> automatically puts all users in that role with the rights to do anything
> >> (subscriptions, deploy reports etc) to Reporting Services. However,
> >> individual users or groups can be added to roles.
> >>
> >> In Report Manager, be at Home. Click on the Properties tab, Click New
> >> Role
> >> Assignments. Try Content Manager or Publisher. One of those roles will
> >> work.
> >>
> >> All other folders inherit from home.
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >>
> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> > Did you check SQL Server Configuration Manager to see if the Reporting
> >> > Services service is started? It could also be a rights issue. Do you
> >> > have
> >> > sysadmin rights on your MSSQL server?
> >> >
> >> > --
> >> >
> >> > Alain Quesnel
> >> > alainsansspam@.logiquel.com
> >> >
> >> > www.logiquel.com
> >> >
> >> >
> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> >> Bonjour!
> >> >>
> >> >> I can't have access with my management studio to Reporting services
> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> >> developpers
> >> >> needs special rights?
> >> >>
> >> >> Regards, Joel :)
> >> >
> >>
> >>
> >>
>
>|||I'm sorry. You asked about the developers so I immediately thought the issue
was not being able to deploy. Hence the thrust of all my posts. I never use
Management studio for anything with RS. I pulled it up just to see what it
offers and it does very little. It shows you some things but Report Manager
can easily do everything and more than what you can do with Management
Studio.
The other poster mentioned sysadmin rights on SQL Server. I don't think this
is necessary because when I look at what information is provided and changes
allowed, it is all straight Reporting Services. If you want developers to be
doing this (adding roles for instance) then have them either be in the local
administrators account on the server that is hosting Reporting Services or
add their account to the System Administrator role.
I suggest first making sure the developers can do what they need to do with
Report Manager.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joel" <Joel@.discussions.microsoft.com> wrote in message
news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@.microsoft.com...
> Yes that's what I do. My little issue here is not in Visual Studio, it is
> when I try to connect to report server with MS SQL Server management
> studio,
> on my test server that I have, everything on one box, it is connecting but
> with my prod it doesn't. My prod is different, the Reporting is installed
> on
> a web server with the database on another server.
> Regards, Joel :)
> "Bruce L-C [MVP]" wrote:
>> Have you specified the path to deploy to? Right mouse click on the
>> project
>> in BI Studio/VS. You need to set the target server URL to something like
>> this:
>> http://yourserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
>> > Thanks Guys, when we are with the browser on Reports Server, they can
>> > deploy
>> > and access it, I made a special role for them, but with management
>> > studio
>> > we
>> > cannot connect to it at all.
>> >
>> > Joel:)
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is
>> >> no
>> >> way that developers should have sysadmin rights on SQL server. RS does
>> >> everything based on its roles.
>> >>
>> >> The local administrators role on the server (server not SQL Server)
>> >> automatically puts all users in that role with the rights to do
>> >> anything
>> >> (subscriptions, deploy reports etc) to Reporting Services. However,
>> >> individual users or groups can be added to roles.
>> >>
>> >> In Report Manager, be at Home. Click on the Properties tab, Click New
>> >> Role
>> >> Assignments. Try Content Manager or Publisher. One of those roles will
>> >> work.
>> >>
>> >> All other folders inherit from home.
>> >>
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >>
>> >>
>> >>
>> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> >> > Did you check SQL Server Configuration Manager to see if the
>> >> > Reporting
>> >> > Services service is started? It could also be a rights issue. Do you
>> >> > have
>> >> > sysadmin rights on your MSSQL server?
>> >> >
>> >> > --
>> >> >
>> >> > Alain Quesnel
>> >> > alainsansspam@.logiquel.com
>> >> >
>> >> > www.logiquel.com
>> >> >
>> >> >
>> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> >> >> Bonjour!
>> >> >>
>> >> >> I can't have access with my management studio to Reporting services
>> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
>> >> >> developpers
>> >> >> needs special rights?
>> >> >>
>> >> >> Regards, Joel :)
>> >> >
>> >>
>> >>
>> >>
>>|||Thanks, that's what I will do.
Regards, Joel :)
"Bruce L-C [MVP]" wrote:
> I'm sorry. You asked about the developers so I immediately thought the issue
> was not being able to deploy. Hence the thrust of all my posts. I never use
> Management studio for anything with RS. I pulled it up just to see what it
> offers and it does very little. It shows you some things but Report Manager
> can easily do everything and more than what you can do with Management
> Studio.
> The other poster mentioned sysadmin rights on SQL Server. I don't think this
> is necessary because when I look at what information is provided and changes
> allowed, it is all straight Reporting Services. If you want developers to be
> doing this (adding roles for instance) then have them either be in the local
> administrators account on the server that is hosting Reporting Services or
> add their account to the System Administrator role.
> I suggest first making sure the developers can do what they need to do with
> Report Manager.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> news:AA154A4E-229A-4F8D-BCBA-8AC2391496A5@.microsoft.com...
> > Yes that's what I do. My little issue here is not in Visual Studio, it is
> > when I try to connect to report server with MS SQL Server management
> > studio,
> > on my test server that I have, everything on one box, it is connecting but
> > with my prod it doesn't. My prod is different, the Reporting is installed
> > on
> > a web server with the database on another server.
> >
> > Regards, Joel :)
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Have you specified the path to deploy to? Right mouse click on the
> >> project
> >> in BI Studio/VS. You need to set the target server URL to something like
> >> this:
> >> http://yourserver/ReportServer
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> news:BD19004F-06AF-48FD-8592-2B8AB74A2BF0@.microsoft.com...
> >> > Thanks Guys, when we are with the browser on Reports Server, they can
> >> > deploy
> >> > and access it, I made a special role for them, but with management
> >> > studio
> >> > we
> >> > cannot connect to it at all.
> >> >
> >> > Joel:)
> >> >
> >> > "Bruce L-C [MVP]" wrote:
> >> >
> >> >> Whoa! To deploy a report to RS does not need sysadmin rights. There is
> >> >> no
> >> >> way that developers should have sysadmin rights on SQL server. RS does
> >> >> everything based on its roles.
> >> >>
> >> >> The local administrators role on the server (server not SQL Server)
> >> >> automatically puts all users in that role with the rights to do
> >> >> anything
> >> >> (subscriptions, deploy reports etc) to Reporting Services. However,
> >> >> individual users or groups can be added to roles.
> >> >>
> >> >> In Report Manager, be at Home. Click on the Properties tab, Click New
> >> >> Role
> >> >> Assignments. Try Content Manager or Publisher. One of those roles will
> >> >> work.
> >> >>
> >> >> All other folders inherit from home.
> >> >>
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >>
> >> >>
> >> >>
> >> >> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> >> >> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> >> > Did you check SQL Server Configuration Manager to see if the
> >> >> > Reporting
> >> >> > Services service is started? It could also be a rights issue. Do you
> >> >> > have
> >> >> > sysadmin rights on your MSSQL server?
> >> >> >
> >> >> > --
> >> >> >
> >> >> > Alain Quesnel
> >> >> > alainsansspam@.logiquel.com
> >> >> >
> >> >> > www.logiquel.com
> >> >> >
> >> >> >
> >> >> > "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> >> > news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> >> >> Bonjour!
> >> >> >>
> >> >> >> I can't have access with my management studio to Reporting services
> >> >> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> >> >> developpers
> >> >> >> needs special rights?
> >> >> >>
> >> >> >> Regards, Joel :)
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>|||I agree that developers shoudn't have sa rights. I just wanted to know if he
could access SSRS through Management Studio with such rights. I've had a
similar issue that had to do with renaming a machine that hosts SSRS. I
still can't make the SSRS webserver work with a new machine name.
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O1BeNPKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> way that developers should have sysadmin rights on SQL server. RS does
> everything based on its roles.
> The local administrators role on the server (server not SQL Server)
> automatically puts all users in that role with the rights to do anything
> (subscriptions, deploy reports etc) to Reporting Services. However,
> individual users or groups can be added to roles.
> In Report Manager, be at Home. Click on the Properties tab, Click New Role
> Assignments. Try Content Manager or Publisher. One of those roles will
> work.
> All other folders inherit from home.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
>> Did you check SQL Server Configuration Manager to see if the Reporting
>> Services service is started? It could also be a rights issue. Do you have
>> sysadmin rights on your MSSQL server?
>> --
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>> "Joel" <Joel@.discussions.microsoft.com> wrote in message
>> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
>> Bonjour!
>> I can't have access with my management studio to Reporting services
>> (2005)installed on my web server. (Cannot connect to...)Do my
>> developpers
>> needs special rights?
>> Regards, Joel :)
>|||Accessing Reporting Services through SQL Server Management Studio DOES have
some good uses.
Mainly, you can organise reports much easier than in Report Manager, you can
also create the rdl from the report.
Having said that, I live with out it because I nearly always hit connection
problems on different sites and I'm not sure of the correct way to set it up.
Anyone got an idiots guide to setting the security up so that this facility
can be done. I have full administrator rights.
Thanks
Chris McGuigan
"Alain Quesnel" wrote:
> I agree that developers shoudn't have sa rights. I just wanted to know if he
> could access SSRS through Management Studio with such rights. I've had a
> similar issue that had to do with renaming a machine that hosts SSRS. I
> still can't make the SSRS webserver work with a new machine name.
>
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O1BeNPKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> > Whoa! To deploy a report to RS does not need sysadmin rights. There is no
> > way that developers should have sysadmin rights on SQL server. RS does
> > everything based on its roles.
> >
> > The local administrators role on the server (server not SQL Server)
> > automatically puts all users in that role with the rights to do anything
> > (subscriptions, deploy reports etc) to Reporting Services. However,
> > individual users or groups can be added to roles.
> >
> > In Report Manager, be at Home. Click on the Properties tab, Click New Role
> > Assignments. Try Content Manager or Publisher. One of those roles will
> > work.
> >
> > All other folders inherit from home.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> >
> > "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> > news:uAqaWJKHIHA.4228@.TK2MSFTNGP02.phx.gbl...
> >> Did you check SQL Server Configuration Manager to see if the Reporting
> >> Services service is started? It could also be a rights issue. Do you have
> >> sysadmin rights on your MSSQL server?
> >>
> >> --
> >>
> >> Alain Quesnel
> >> alainsansspam@.logiquel.com
> >>
> >> www.logiquel.com
> >>
> >>
> >> "Joel" <Joel@.discussions.microsoft.com> wrote in message
> >> news:598AD496-F255-4AB9-9DFD-DEE860D45F6F@.microsoft.com...
> >> Bonjour!
> >>
> >> I can't have access with my management studio to Reporting services
> >> (2005)installed on my web server. (Cannot connect to...)Do my
> >> developpers
> >> needs special rights?
> >>
> >> Regards, Joel :)
> >>
> >
> >
>sql
Can't access properties on Stored Procedures
Hi. I have set up an instance of SQL 2005 on my local computer. I use MS SQL Server Management Studio to login into my 2005 instance via Windows login. When I expand "Stored Procedures" under "Programmability" of the Database I want and go to a stored procedure and right click, I don't see the "properities" selection.
I know it's there because I can get to it on other instances but I can't get to it on my local instance. I added my windows user to my Logins and then to my database users but it didn't help.
Can anyone please tell me what I need to do so I can access the properties of the stored procedures?
Thanks
Your procedure was created with encryption option. Because this you can′t see the contents.
|||Its either an encryption problem (like already mentioned by the other poster) or you don′t have the appropiate permissions viewing the properties. Which access level does the account you are using have ? Is there a pas lock on the stored procedure symbol ?Jens K. Suessmeyer.
http://www.sqlserver2005.de
Monday, March 19, 2012
Cann't create Legacy (SQL 2000) Maintenance Plans
I recently installed the SQL Server 2005 Management Studio on my workstation
and the install of this new tool removed the old SQL Server 2000 Enterprise
Manager.
Since 99% of my installed server base is still SQL Server 2000, here’s my
question.
How am I supposed to manage my SQL Server 2000 instances with the SQL Server
2005 tools?
When I connect to a SQL Server 2000 instance, using SQL 2005 Management
Studio, I can see under Legacy -> Database Maintenance Plans, the existing
plans; however I cannot create any new Legacy Maintenance plans.
Kurt
It sounds bad but you should have thought of that before you upgraded then.
The documentation in 2005 clearly spells this out. If you need to change or
create new 2000 maintenance plans then you should have a machine with 2000
EM on it for that purpose. You must have chosen to upgrade your existing
instance instead of doing a side by side installation. There is no problem
running 2000 and 2005 on the same box and having both EM and SSMS running at
the same time. You can reinstall 2000 client tools but I am not sure if you
need to uninstall 2005 first or not. I would try it first and see.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"kmoskal@.newsgroups.nospam" <zork@.newsgroups.nospam> wrote in message
news:1FC128B9-88F0-42CA-8684-1445A06BA3B0@.microsoft.com...
>I recently installed the SQL Server 2005 Management Studio on my
>workstation
> and the install of this new tool removed the old SQL Server 2000
> Enterprise
> Manager.
> Since 99% of my installed server base is still SQL Server 2000, here’s my
> question.
> How am I supposed to manage my SQL Server 2000 instances with the SQL
> Server
> 2005 tools?
> When I connect to a SQL Server 2000 instance, using SQL 2005 Management
> Studio, I can see under Legacy -> Database Maintenance Plans, the existing
> plans; however I cannot create any new Legacy Maintenance plans.
>
>
>
> --
> Kurt
and the install of this new tool removed the old SQL Server 2000 Enterprise
Manager.
Since 99% of my installed server base is still SQL Server 2000, here’s my
question.
How am I supposed to manage my SQL Server 2000 instances with the SQL Server
2005 tools?
When I connect to a SQL Server 2000 instance, using SQL 2005 Management
Studio, I can see under Legacy -> Database Maintenance Plans, the existing
plans; however I cannot create any new Legacy Maintenance plans.
Kurt
It sounds bad but you should have thought of that before you upgraded then.
The documentation in 2005 clearly spells this out. If you need to change or
create new 2000 maintenance plans then you should have a machine with 2000
EM on it for that purpose. You must have chosen to upgrade your existing
instance instead of doing a side by side installation. There is no problem
running 2000 and 2005 on the same box and having both EM and SSMS running at
the same time. You can reinstall 2000 client tools but I am not sure if you
need to uninstall 2005 first or not. I would try it first and see.
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"kmoskal@.newsgroups.nospam" <zork@.newsgroups.nospam> wrote in message
news:1FC128B9-88F0-42CA-8684-1445A06BA3B0@.microsoft.com...
>I recently installed the SQL Server 2005 Management Studio on my
>workstation
> and the install of this new tool removed the old SQL Server 2000
> Enterprise
> Manager.
> Since 99% of my installed server base is still SQL Server 2000, here’s my
> question.
> How am I supposed to manage my SQL Server 2000 instances with the SQL
> Server
> 2005 tools?
> When I connect to a SQL Server 2000 instance, using SQL 2005 Management
> Studio, I can see under Legacy -> Database Maintenance Plans, the existing
> plans; however I cannot create any new Legacy Maintenance plans.
>
>
>
> --
> Kurt
Thursday, March 8, 2012
cannot upgrade management studio
Hi,
I have clean install of Vista and Orcas March CTP. Vista automatically downloaded SP2 for SQL services. It does not come with Management Studio however, so I have to download it from web. There is only unupdated version for download, so I downloaded it and installed it. It does not work of course, but when I run the SP2 pack, it wrote me that half of the products are already updated and half of them are not updatable by the pack.
What should I do?
SQL Server SP2 does update the enterprise Management Studio, so I assume you are talking about Management Studio Express.
You should be able to uninstall Management Studio Express and then install Management Studio Express SP2 from this web site: http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en If you've already done that, you can verify that you have Management Studio Express SP2 by starting the application and then looking at the Help > About... dialog. SP2 is version 9.0.3042.
Hope this helps,
Steve
|||As explained you can accomplish as per the explanation above, if you are using ENterprise Management studio then you might try again applying the Service pack2.
cannot upgrade management studio
Hi,
I have clean install of Vista and Orcas March CTP. Vista automatically downloaded SP2 for SQL services. It does not come with Management Studio however, so I have to download it from web. There is only unupdated version for download, so I downloaded it and installed it. It does not work of course, but when I run the SP2 pack, it wrote me that half of the products are already updated and half of them are not updatable by the pack.
What should I do?
SQL Server SP2 does update the enterprise Management Studio, so I assume you are talking about Management Studio Express.
You should be able to uninstall Management Studio Express and then install Management Studio Express SP2 from this web site: http://www.microsoft.com/downloads/details.aspx?familyid=6053C6F8-82C8-479C-B25B-9ACA13141C9E&displaylang=en If you've already done that, you can verify that you have Management Studio Express SP2 by starting the application and then looking at the Help > About... dialog. SP2 is version 9.0.3042.
Hope this helps,
Steve
|||As explained you can accomplish as per the explanation above, if you are using ENterprise Management studio then you might try again applying the Service pack2.Wednesday, March 7, 2012
Cannot subscribe report
Has anybody experienced this strange problem? I can create a e-mail
subscription in Management Studio. However, when I am in web based
subscription, type in the entries and click "OK", the next screen asks me to
"specify options for report delivery" again. No matter what I choose ("Report
Server E-mail" or "Report Server File Share"), it prompt back to the same
screen.
Any tip or help is very much appreciated.Hello Jason,
I would like to know have you applied SP1 on your reporting services?
Also, if you created a subscription in the Management Studio and then try
to modify the subscription in the web site, do you still get this issue?
And if you tested on other client, does this issue still occur?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||yes, I did apply sp1. and yes, I get the same issue when I try to modify the
subscription. I tested on both my machine (xp) and the server itself, same
thing happens. Thank you for any troubleshooting clues.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> I would like to know have you applied SP1 on your reporting services?
> Also, if you created a subscription in the Management Studio and then try
> to modify the subscription in the web site, do you still get this issue?
> And if you tested on other client, does this issue still occur?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Jason,
Have you seen any error message in the Report Log?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please check and let me know are there any related error in the log.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you for the help. I checked the WebApp log, the following looks
suspicious:
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
No idea what does the above mean.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Actually, the report subscription is working and the email is delivered after
I set it up in Management Studio. My problem is I can not use Management
Studio to set up other reports which requires parameters. If I understand
right, those reports subscription has to be done through report server web
interface. That is why I am having the problem. Please help.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Jason,
I would like to get all the Report Error log.
Also, please check your rsReportServer.config file and make sure the smtp
server name is correct.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you, my direct email address is
weilu@.ONLINE.microsoft.com ( Please remove ONLINE when you send the email
), you may send the file to me directly and I will keep it secure..
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
subscription in Management Studio. However, when I am in web based
subscription, type in the entries and click "OK", the next screen asks me to
"specify options for report delivery" again. No matter what I choose ("Report
Server E-mail" or "Report Server File Share"), it prompt back to the same
screen.
Any tip or help is very much appreciated.Hello Jason,
I would like to know have you applied SP1 on your reporting services?
Also, if you created a subscription in the Management Studio and then try
to modify the subscription in the web site, do you still get this issue?
And if you tested on other client, does this issue still occur?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||yes, I did apply sp1. and yes, I get the same issue when I try to modify the
subscription. I tested on both my machine (xp) and the server itself, same
thing happens. Thank you for any troubleshooting clues.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> I would like to know have you applied SP1 on your reporting services?
> Also, if you created a subscription in the Management Studio and then try
> to modify the subscription in the web site, do you still get this issue?
> And if you tested on other client, does this issue still occur?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> Get notification to my posts through email? Please refer to
> http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
> ications.
> Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
> where an initial response from the community or a Microsoft Support
> Engineer within 1 business day is acceptable. Please note that each follow
> up response may take approximately 2 business days as the support
> professional working with you may need further investigation to reach the
> most efficient resolution. The offering is not appropriate for situations
> that require urgent, real-time or phone-based interactions or complex
> project analysis and dump analysis issues. Issues of this nature are best
> handled working with a dedicated Microsoft Support Engineer by contacting
> Microsoft Customer Support Services (CSS) at
> http://msdn.microsoft.com/subscriptions/support/default.aspx.
> ==================================================> (This posting is provided "AS IS", with no warranties, and confers no
> rights.)
>|||Hello Jason,
Have you seen any error message in the Report Log?
By default, the log file is located at \Microsoft SQL Server\<SQL Server
Instance>\Reporting Services\LogFiles.
Please check and let me know are there any related error in the log.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you for the help. I checked the WebApp log, the following looks
suspicious:
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:31:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!6!11/14/2006-08:09:34:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!5!11/14/2006-08:09:37:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!1!11/14/2006-08:09:39:: w WARN: The extension Report
Server FileShare does not have a LocalizedNameAttribute.
No idea what does the above mean.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Actually, the report subscription is working and the email is delivered after
I set it up in Management Studio. My problem is I can not use Management
Studio to set up other reports which requires parameters. If I understand
right, those reports subscription has to be done through report server web
interface. That is why I am having the problem. Please help.
"Wei Lu [MSFT]" wrote:
> Hello Jason,
> Have you seen any error message in the Report Log?
> By default, the log file is located at \Microsoft SQL Server\<SQL Server
> Instance>\Reporting Services\LogFiles.
> Please check and let me know are there any related error in the log.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hello Jason,
I would like to get all the Report Error log.
Also, please check your rsReportServer.config file and make sure the smtp
server name is correct.
You may zip the folder and send to me directly. I understand the
information may be sensitive to you, my direct email address is
weilu@.ONLINE.microsoft.com ( Please remove ONLINE when you send the email
), you may send the file to me directly and I will keep it secure..
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)
Saturday, February 25, 2012
Cannot start SQL Server 2005 management express studio CTP?
I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
> >I downloaded it from the link in
> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> > version.
> > And it cannot be run on two machines. Both installed VS 2003.
>
>|||No. SQL Express is RTM. SSME is CTP.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
>> --
>> William Stacey [MVP]
>> "nick" <nick@.discussions.microsoft.com> wrote in message
>> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>> >I downloaded it from the link in
>> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
>> > version.
>> > And it cannot be run on two machines. Both installed VS 2003.
>>
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
> >I downloaded it from the link in
> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> > version.
> > And it cannot be run on two machines. Both installed VS 2003.
>
>|||No. SQL Express is RTM. SSME is CTP.
--
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
>> --
>> William Stacey [MVP]
>> "nick" <nick@.discussions.microsoft.com> wrote in message
>> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>> >I downloaded it from the link in
>> > http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
>> > version.
>> > And it cannot be run on two machines. Both installed VS 2003.
>>
Cannot start SQL Server 2005 management express studio CTP?
I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.
http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.
|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>
|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.
http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.
|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>
|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
Cannot start SQL Server 2005 management express studio CTP?
I downloaded it from the link in
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>
http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP version.
And it cannot be run on two machines. Both installed VS 2003.http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>I downloaded it from the link in
> http://msdn.microsoft.com/vstudio/express/sql/. It's still Nov CTP
> version.
> And it cannot be run on two machines. Both installed VS 2003.|||Still CTP:
"Get SQL Server Management Studio Express
Download a Community Technology Preview (CTP) of SQL Server Management
Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
Express that makes it easy for you to administer SQL Server Express
databases."
"William Stacey [MVP]" wrote:
> http://msdn.microsoft.com/sql/express/default.aspx has RTM version.
> --
> William Stacey [MVP]
> "nick" <nick@.discussions.microsoft.com> wrote in message
> news:4ECA7D5A-6987-41E5-A1DD-41C49D190BBC@.microsoft.com...
>
>|||No. SQL Express is RTM. SSME is CTP.
William Stacey [MVP]
"nick" <nick@.discussions.microsoft.com> wrote in message
news:E8E707DD-793B-4D99-978A-03ECAAA3DE98@.microsoft.com...[vbcol=seagreen]
> Still CTP:
> "Get SQL Server Management Studio Express
> Download a Community Technology Preview (CTP) of SQL Server Management
> Studio Express (SSMSE). SSMSE is a free graphical management tool for SQL
> Express that makes it easy for you to administer SQL Server Express
> databases."
> "William Stacey [MVP]" wrote:
>
cannot start or verify that SQL 2005 is running
Hi,
I am new to sql 2005.
I have installed a trial version of 2005 enterprise edition.
After installing I went to Management Studio. I noticed that the server name
dropdown menu was blank so I tried to browse. No server names appear under local
or network servers. I then went to configuration manager and noticed that
although client protocols are listed under SQL client native config,
SQL server 2005 services and sql server 2005 network config are both blank. Is SQL
installed correctly? I hope this is enough info to illicit a helpful response.
Thank You.
Problem solved. I went to add remove apps and clicked change
on Microsoft SQL Server 2005 button. I am not sure what Microsoft
SQL Server Native Client is so I didn't mess with it. I saw that no instances
were listed under SQL Server 2005 instances so I clicked away until I had
added an instance - MSSQLSERVER. I am going to be using .net 2.0 framework
objects to connect to SQL so I am not sure if I messed up by Not installing in
mixed mode. Any advice on the mixed mode issue would be appreciated.
|||If you have no need for mixed mode, then don't install it. It kind of sounds like you don't so no worries.Cannot start configuration manager on 1 of our active nodes
On one of our active nodes we cannot start the configuration manager but we
can start management studio.
We get the error message "Connection to target machine cannot be made in a
timely fashion". Any ideas on what causes this and how to fix?
Thanks
Is this for a Named Instance installation, on a non-standard port?
If so, then it probably works fine on the active node, but the remote node
times out?
Create a client-side alias on each node; sometimes the port resolution does
not work properly.
Are you running the SQL Browser service on each node?
Sincerely,
Anthony Thomas
"Randy" <Randy@.discussions.microsoft.com> wrote in message
news:A3FC4759-C823-400D-B9C0-651F5BA7BCD1@.microsoft.com...
> On one of our active nodes we cannot start the configuration manager but
we
> can start management studio.
> We get the error message "Connection to target machine cannot be made in a
> timely fashion". Any ideas on what causes this and how to fix?
> Thanks
can start management studio.
We get the error message "Connection to target machine cannot be made in a
timely fashion". Any ideas on what causes this and how to fix?
Thanks
Is this for a Named Instance installation, on a non-standard port?
If so, then it probably works fine on the active node, but the remote node
times out?
Create a client-side alias on each node; sometimes the port resolution does
not work properly.
Are you running the SQL Browser service on each node?
Sincerely,
Anthony Thomas
"Randy" <Randy@.discussions.microsoft.com> wrote in message
news:A3FC4759-C823-400D-B9C0-651F5BA7BCD1@.microsoft.com...
> On one of our active nodes we cannot start the configuration manager but
we
> can start management studio.
> We get the error message "Connection to target machine cannot be made in a
> timely fashion". Any ideas on what causes this and how to fix?
> Thanks
Sunday, February 19, 2012
Cannot show requested dialog
Hi,
when i try to see the properties of database "sales" (sql server express
2005) in Management Studio Express, i get this error message: (besides,
when i try to expand the database, i get the error that it's emty)
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--
The server principal "SRV754\admin" is not able to access the database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any way to recover it?
Thanks
DavidTake a look at the following KB David,
http://support.microsoft.com/kb/913422
Ekrem nsoy
"David" <no@.spam.rt> wrote in message
news:%23vPLrBDQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> Hi,
> when i try to see the properties of database "sales" (sql server express
> 2005) in Management Studio Express, i get this error message: (besides,
> when i try to expand the database, i get the error that it's emty)
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> The server principal "SRV754\admin" is not able to access the database
> "sales" under the current security context. (Microsoft SQL Server, Error:
> 916)
> But the webapplication still runs: i can insert records, update, delete
> ... from asp.net.
> Any way to recover it?
> Thanks
> David
>
when i try to see the properties of database "sales" (sql server express
2005) in Management Studio Express, i get this error message: (besides,
when i try to expand the database, i get the error that it's emty)
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--
The server principal "SRV754\admin" is not able to access the database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any way to recover it?
Thanks
DavidTake a look at the following KB David,
http://support.microsoft.com/kb/913422
Ekrem nsoy
"David" <no@.spam.rt> wrote in message
news:%23vPLrBDQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> Hi,
> when i try to see the properties of database "sales" (sql server express
> 2005) in Management Studio Express, i get this error message: (besides,
> when i try to expand the database, i get the error that it's emty)
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> The server principal "SRV754\admin" is not able to access the database
> "sales" under the current security context. (Microsoft SQL Server, Error:
> 916)
> But the webapplication still runs: i can insert records, update, delete
> ... from asp.net.
> Any way to recover it?
> Thanks
> David
>
Cannot show requested dialog
Hi,
when i try to see the properties of database "sales" (sql server express
2005) in Management Studio Express, i get this error message: (besides,
when i try to expand the database, i get the error that it's emty)
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
----------
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
----------
The server principal "Myserver\admin" is not able to access the database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any way to recover it?
Thanks
Tartuffe
Hi,
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
From your description, it seems that you failed to connect to your database from the SQLServer Management Studio Express and the error message displays, right?
I suggest that you should use command line utility to connect to express and change the setting.
i.e.
sqlcmd -S".\Express" -Q"exec sp_configure 'user connections','32767';
reconfigure with override"
Thanks.
Thanks for replying.
I couldn't try your solution because when i type sqlcmd, i get an error:
"could not open a connection" ... "login time-out has expired".
I checked the services which are:
remote connections: both tcp/ip and names pipes
sql service browsing: running
??
|||sorry, when i do sqlcmd -S servername\sqlexpress i get in.
Now i typed your solution but i presume i have to change 'user connections' with 'servername\myaccount'?
Do i have to type '32767' with the quotes or without them?
i typed this:
sqlcmd -S servername\sqlexpress -Q exec sp_configure 'servername\myaccount','32767';
reconfigure with override
but this gives: unexpected argument
|||
Hi,
For more information on sqlcmd tool, see:http://technet.microsoft.com/zh-cn/library/ms162773.aspx
sp_configure is a stored procedure name to be executed.
"user connections" is the option name, not 'servername\myaccount', and '32767' is the value we set for that option.
For more information on the usage of the sp_configure procs, see:http://technet.microsoft.com/en-us/library/ms188787.aspx
Thanks.
Cannot show requested dialog
Hi,
when i try to see the properties of database "sales" (sql server express
2005) in Management Studio Express, i get this error message: (besides,
when i try to expand the database, i get the error that it's emty)
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--
The server principal "SRV754\admin" is not able to access the database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any way to recover it?
Thanks
DavidTake a look at the following KB David,
http://support.microsoft.com/kb/913422
--
Ekrem Önsoy
"David" <no@.spam.rt> wrote in message
news:%23vPLrBDQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> Hi,
> when i try to see the properties of database "sales" (sql server express
> 2005) in Management Studio Express, i get this error message: (besides,
> when i try to expand the database, i get the error that it's emty)
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> The server principal "SRV754\admin" is not able to access the database
> "sales" under the current security context. (Microsoft SQL Server, Error:
> 916)
> But the webapplication still runs: i can insert records, update, delete
> ... from asp.net.
> Any way to recover it?
> Thanks
> David
>
when i try to see the properties of database "sales" (sql server express
2005) in Management Studio Express, i get this error message: (besides,
when i try to expand the database, i get the error that it's emty)
Cannot show requested dialog.
ADDITIONAL INFORMATION:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
--
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
--
The server principal "SRV754\admin" is not able to access the database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any way to recover it?
Thanks
DavidTake a look at the following KB David,
http://support.microsoft.com/kb/913422
--
Ekrem Önsoy
"David" <no@.spam.rt> wrote in message
news:%23vPLrBDQIHA.2208@.TK2MSFTNGP06.phx.gbl...
> Hi,
> when i try to see the properties of database "sales" (sql server express
> 2005) in Management Studio Express, i get this error message: (besides,
> when i try to expand the database, i get the error that it's emty)
> Cannot show requested dialog.
> ADDITIONAL INFORMATION:
> Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
> --
> An exception occurred while executing a Transact-SQL statement or batch.
> (Microsoft.SqlServer.Express.ConnectionInfo)
> --
> The server principal "SRV754\admin" is not able to access the database
> "sales" under the current security context. (Microsoft SQL Server, Error:
> 916)
> But the webapplication still runs: i can insert records, update, delete
> ... from asp.net.
> Any way to recover it?
> Thanks
> David
>
Subscribe to:
Posts (Atom)