I have a SQL server 2005 box with 8 GB physical memory. The windows task
manager reports 7.4G PF Usage. Is this accurate?Hello,
It should be correct. But use the performance monitor to measure the correct
usage. Take a look int the below URL:-
http://msdn2.microsoft.com/en-us/library/ms176018.aspx
Thanks
Hari
"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:55174532-F7F0-4EEC-8427-81C271DFF935@.microsoft.com...
>I have a SQL server 2005 box with 8 GB physical memory. The windows task
> manaer reports 7.4G PF Usage. Is this accurate?
Showing posts with label box. Show all posts
Showing posts with label box. Show all posts
Friday, March 30, 2012
Pervasive SQL in same box as MSSQL 2000 ?
Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
would there be any problems setting both up in the same box ?
It works. Still have a few of those in production environment. Hope you are
not using Pervasive for new stuff:-) Bad enough to have legacy crap depend
on it. We are phasing out all Pervasive stuff (and SQL 2000 for that matter)
hope it helps
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F019D688-692A-4F5E-9273-425E0D671C86@.microsoft.com...
> Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
> would there be any problems setting both up in the same box ?
would there be any problems setting both up in the same box ?
It works. Still have a few of those in production environment. Hope you are
not using Pervasive for new stuff:-) Bad enough to have legacy crap depend
on it. We are phasing out all Pervasive stuff (and SQL 2000 for that matter)
hope it helps
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F019D688-692A-4F5E-9273-425E0D671C86@.microsoft.com...
> Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
> would there be any problems setting both up in the same box ?
Pervasive SQL in same box as MSSQL 2000 ?
Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
would there be any problems setting both up in the same box ?It works. Still have a few of those in production environment. Hope you are
not using Pervasive for new stuff:-) Bad enough to have legacy crap depend
on it. We are phasing out all Pervasive stuff (and SQL 2000 for that matter)
hope it helps
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F019D688-692A-4F5E-9273-425E0D671C86@.microsoft.com...
> Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
> would there be any problems setting both up in the same box ?sql
would there be any problems setting both up in the same box ?It works. Still have a few of those in production environment. Hope you are
not using Pervasive for new stuff:-) Bad enough to have legacy crap depend
on it. We are phasing out all Pervasive stuff (and SQL 2000 for that matter)
hope it helps
"Dennis" <Dennis@.discussions.microsoft.com> wrote in message
news:F019D688-692A-4F5E-9273-425E0D671C86@.microsoft.com...
> Has anyone installed pervasive SQL in the same box as MSSQL 2000 ?
> would there be any problems setting both up in the same box ?sql
Personal Web Developer Kit SQL Error
Hi folks,
I get this error message when I try to run my personal web page starter kit (Ctrl + F5) which has come straight out of the box:
Server Error in '/WebSite1' Application.
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this 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)
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
SQLExpress database file auto-creation error:
The connection string specifies a local Sql Server Express instance using a database location within the applications App_Data directory. The provider attempted to automatically create the application services database because the provider determined that the database does not exist. The following configuration requirements are necessary to successfully check for existence of the application services database and automatically create the application services database:
- If the applications App_Data directory does not already exist, the web server account must have read and write access to the applications directory. This is necessary because the web server account will automatically create the App_Data directory if it does not already exist. If the applications App_Data directory already exists, the web server account only requires read and write access to the applications App_Data directory. This is necessary because the web server account will attempt to verify that the Sql Server Express database already exists within the applications App_Data directory. Revoking read access on the App_Data directory from the web server account will prevent the provider from correctly determining if the Sql Server Express database already exists. This will cause an error when the provider attempts to create a duplicate of an already existing database. Write access is required because the web server accounts credentials are used when creating the new database. Sql Server Express must be installed on the machine. The process identity for the web server account must have a local user profile. See the readme document for details on how to create a local user profile for both machine and domain accounts.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace:
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210
In my web administration tool, under the Security tab the following error is listed:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: Unable to connect to SQL Server database.
and under the provider tab the provider is listed as: AspNetSqlProvider.
So what do I need to do?
(By the way, I wasn't exactly sure where to put this post, but if it gets moved to another forum please may you post the new link? Cheers)
In the default installation, SQL Server installs with very tight security.
Please refer to these articles for help in setting the correct configuration parameters.
Configuration -Configure SQL Server 2005 to allow remote connections
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
Configuration -Connect to SQL Express from "downlevel clients"
http://blogs.msdn.com/sqlexpress/archive/2004/07/23/192044.aspx
Configuration -Connect to SQL Express and ‘Stay Connected’
http://betav.com/blog/billva/2006/06/getting_and_staying_connected.html
Configuration - Guideline for Connectivity Question Posting
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=362498&SiteID=1
|||
heebiej wrote:
I don't seem to have SQL Server 2005 installed (it's not in the start menu, nor in Program Files). Do you think this is the problem? Do I need to install it, and if so, where from?
That could be a problem after you install it you still need to use the surface area configuration tool to enable browser services and allow remote and local connection then enable both TCP/IP and Named Pipes. Try the link below to download SQL Server Express with Advanced features, one more thing there are many user improved version of this kit you may want to check the forum for this kit at the Asp.net forums. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/download/advanced/default.aspx
|||You can download a copy of SQL Server 2005 Express from here.Monday, March 26, 2012
Permissions when linking to reports
Hi,
I've adding a link from my web app to reports sitting on another box. However, that box is asking the user to login. How do I set the permissions to avoid it?Would like to help!
What OS are your "boxes" running ?
Are you using Active Directory?
Are your "boxes" on the same intranet ?
What security schema are you using with SQL connections?
Best Regards,
Friday, March 23, 2012
Permissions to data source in Report Manager
I'm deploying some reports to a customer box and am having some quirks
in getting the right permissions to the data source. Instead of going
into detail about my specific problem (which I don't think I can even
give a good description of since I can't see what groups the accounts
I'm using are members of because I don't have access to their AD), can
someone give a list of the permissions required on an account in order
to access a data source? SQL permissions? Report Server permissions? If
I were to create an account purely for accessing the data source for
the reports, is there a complete checklist that I could follow to
ensure all the proper permissions?
Thanks.Oh, btw, I'm concerned about permissions to standard sql database
tables/views, and possibly OLAP cubes.
Thanks!|||Anybody?|||Bueller?
Bueller?
Bueller?|||All right, well I figured it out, at least for SQL Server access. I
guess all a domain account needs is public and db_datareader access to
the db you're getting data out of. Any ideas if it's pretty much the
same if trying to get data from an OLAP cube?|||What you are doing here is using the users account for accessing the
database. I think this is a mistake. First, it makes management of the users
more difficult. Now, every time there is a user that needs to run a report
you have to mess with DB access. Also, by doing this your RS will not be
able to take advantage of connection pooling (connection pooling only works
if everything is exactly the same, which includes the user). What I do is
have a special user that is used only for RS data access and is given
readonly rights to the data. I use RS roles to determine who gets to run
which reports.
The other thing I do is add domain groups and users to a local group on the
server and use that local group with RS roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wannabe_Kiwi" <amkessel@.gmail.com> wrote in message
news:1150908395.063069.70970@.c74g2000cwc.googlegroups.com...
> All right, well I figured it out, at least for SQL Server access. I
> guess all a domain account needs is public and db_datareader access to
> the db you're getting data out of. Any ideas if it's pretty much the
> same if trying to get data from an OLAP cube?
>|||I'm using a single, special domain account to access all the data
sources for all the reports, not using a bunch of individual user
accounts.
I'm still stuck on getting access to the SQL Analysis OLAP cubes, tho.
I can easily set permissions for SQL databases in Enterprise Manager,
but there doesn't seem to be an equivalent in Analysis Manager. Ideas?
in getting the right permissions to the data source. Instead of going
into detail about my specific problem (which I don't think I can even
give a good description of since I can't see what groups the accounts
I'm using are members of because I don't have access to their AD), can
someone give a list of the permissions required on an account in order
to access a data source? SQL permissions? Report Server permissions? If
I were to create an account purely for accessing the data source for
the reports, is there a complete checklist that I could follow to
ensure all the proper permissions?
Thanks.Oh, btw, I'm concerned about permissions to standard sql database
tables/views, and possibly OLAP cubes.
Thanks!|||Anybody?|||Bueller?
Bueller?
Bueller?|||All right, well I figured it out, at least for SQL Server access. I
guess all a domain account needs is public and db_datareader access to
the db you're getting data out of. Any ideas if it's pretty much the
same if trying to get data from an OLAP cube?|||What you are doing here is using the users account for accessing the
database. I think this is a mistake. First, it makes management of the users
more difficult. Now, every time there is a user that needs to run a report
you have to mess with DB access. Also, by doing this your RS will not be
able to take advantage of connection pooling (connection pooling only works
if everything is exactly the same, which includes the user). What I do is
have a special user that is used only for RS data access and is given
readonly rights to the data. I use RS roles to determine who gets to run
which reports.
The other thing I do is add domain groups and users to a local group on the
server and use that local group with RS roles.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wannabe_Kiwi" <amkessel@.gmail.com> wrote in message
news:1150908395.063069.70970@.c74g2000cwc.googlegroups.com...
> All right, well I figured it out, at least for SQL Server access. I
> guess all a domain account needs is public and db_datareader access to
> the db you're getting data out of. Any ideas if it's pretty much the
> same if trying to get data from an OLAP cube?
>|||I'm using a single, special domain account to access all the data
sources for all the reports, not using a bunch of individual user
accounts.
I'm still stuck on getting access to the SQL Analysis OLAP cubes, tho.
I can easily set permissions for SQL databases in Enterprise Manager,
but there doesn't seem to be an equivalent in Analysis Manager. Ideas?
Tuesday, March 20, 2012
permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are ins
I am trying to read the WebServices to gather information about the catalog.
When I run the application from my development box and reading from the
Reporting Services server for the Catalog all run fine.
But when I transfer the application (asp.net) to the server it fails with:
System.Web.Services.Protocols.SoapException: The permissions granted to user
'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this
operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient
for performing this operation. at
Microsoft.ReportingServices.Library.RSService.ListChildren(String item,
Boolean recursive) at
Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
Item, Boolean Recursive, CatalogItem[]& CatalogItems) -- End of inner
exception stack trace -- at
Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
Item, Boolean Recursive, CatalogItem[]& CatalogItems)
The code is quite simple:
VB.NET
Dim rService As ReportingService = New ReportingService
rService.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim catalogItems As CatalogItem()
catalogItems = rService.ListChildren(Global.ReportPath, True)
C#.NET
ReportingService rService = new ReportingService();
rService.Credentials = System.Net.CredentialCache.DefaultCredentials;
CatalogItem[][0] catalogItems;
catalogItems = rService.ListChildren(Global.ReportPath, true);
--
Regards
<<<Bryan Avery>>Found the problem to be with web.config file.
Adding the following line under
<authentication mode="Windows" />
<identity impersonate="true" />
And it all springs in to life
--
Regards
<<<Bryan Avery>>
"Bryan Avery" wrote:
> I am trying to read the WebServices to gather information about the catalog.
> When I run the application from my development box and reading from the
> Reporting Services server for the Catalog all run fine.
> But when I transfer the application (asp.net) to the server it fails with:
> System.Web.Services.Protocols.SoapException: The permissions granted to user
> 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this
> operation. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
> permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient
> for performing this operation. at
> Microsoft.ReportingServices.Library.RSService.ListChildren(String item,
> Boolean recursive) at
> Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
> Item, Boolean Recursive, CatalogItem[]& CatalogItems) -- End of inner
> exception stack trace -- at
> Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
> Item, Boolean Recursive, CatalogItem[]& CatalogItems)
> The code is quite simple:
> VB.NET
> Dim rService As ReportingService = New ReportingService
> rService.Credentials => System.Net.CredentialCache.DefaultCredentials
> Dim catalogItems As CatalogItem()
> catalogItems = rService.ListChildren(Global.ReportPath, True)
> C#.NET
> ReportingService rService = new ReportingService();
> rService.Credentials => System.Net.CredentialCache.DefaultCredentials;
> CatalogItem[][0] catalogItems;
> catalogItems = rService.ListChildren(Global.ReportPath, true);
> --
> Regards
> <<<Bryan Avery>>
When I run the application from my development box and reading from the
Reporting Services server for the Catalog all run fine.
But when I transfer the application (asp.net) to the server it fails with:
System.Web.Services.Protocols.SoapException: The permissions granted to user
'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this
operation. -->
Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient
for performing this operation. at
Microsoft.ReportingServices.Library.RSService.ListChildren(String item,
Boolean recursive) at
Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
Item, Boolean Recursive, CatalogItem[]& CatalogItems) -- End of inner
exception stack trace -- at
Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
Item, Boolean Recursive, CatalogItem[]& CatalogItems)
The code is quite simple:
VB.NET
Dim rService As ReportingService = New ReportingService
rService.Credentials = System.Net.CredentialCache.DefaultCredentials
Dim catalogItems As CatalogItem()
catalogItems = rService.ListChildren(Global.ReportPath, True)
C#.NET
ReportingService rService = new ReportingService();
rService.Credentials = System.Net.CredentialCache.DefaultCredentials;
CatalogItem[][0] catalogItems;
catalogItems = rService.ListChildren(Global.ReportPath, true);
--
Regards
<<<Bryan Avery>>Found the problem to be with web.config file.
Adding the following line under
<authentication mode="Windows" />
<identity impersonate="true" />
And it all springs in to life
--
Regards
<<<Bryan Avery>>
"Bryan Avery" wrote:
> I am trying to read the WebServices to gather information about the catalog.
> When I run the application from my development box and reading from the
> Reporting Services server for the Catalog all run fine.
> But when I transfer the application (asp.net) to the server it fails with:
> System.Web.Services.Protocols.SoapException: The permissions granted to user
> 'NT AUTHORITY\NETWORK SERVICE' are insufficient for performing this
> operation. -->
> Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The
> permissions granted to user 'NT AUTHORITY\NETWORK SERVICE' are insufficient
> for performing this operation. at
> Microsoft.ReportingServices.Library.RSService.ListChildren(String item,
> Boolean recursive) at
> Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
> Item, Boolean Recursive, CatalogItem[]& CatalogItems) -- End of inner
> exception stack trace -- at
> Microsoft.ReportingServices.WebServer.ReportingService.ListChildren(String
> Item, Boolean Recursive, CatalogItem[]& CatalogItems)
> The code is quite simple:
> VB.NET
> Dim rService As ReportingService = New ReportingService
> rService.Credentials => System.Net.CredentialCache.DefaultCredentials
> Dim catalogItems As CatalogItem()
> catalogItems = rService.ListChildren(Global.ReportPath, True)
> C#.NET
> ReportingService rService = new ReportingService();
> rService.Credentials => System.Net.CredentialCache.DefaultCredentials;
> CatalogItem[][0] catalogItems;
> catalogItems = rService.ListChildren(Global.ReportPath, true);
> --
> Regards
> <<<Bryan Avery>>
Permissions for SSAS Service Account?
Hi All,
Please help with this.
I'm running a server with Windows Server 2003 R2 Enterprise x64 Edition.
On the box I've performed one named instance installation of SSAS.
I've installed SP1 as well.
There's no firewall running on the machine.
My domain account is in the SSAS Server role.
SSAS Service is running according to SQL Configuration Manager
SQL Browser Service is running according to SQL Configuration Manager
If I run both SSAS and SQL Browser under Local System, everything works OK. But this is not the way I want it, because it's not safe and SSAS is unable to read data from the remote SQL box.
If I change the service account to a domain user account, I can't connect to SSAs anymore. The error message is:
TITLE: Microsoft SQL Server Management Studio
A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK
I've both set the logon account at setup, using SQL Config Mgr and Service Manager.
Using PortQry I can see nothing's listening on port 2382.
It should work. I'm beginning to think this user account doesn't have sufficient rights.
So I've created two local accounts and used these as service accounts. Same thing, untill I added both accounts to the local administrators group, then everything worked fine again.
What am I doing wrong here? Your suggestions are much appreciated.
Thanks,
Coen
Hello. You have another configuration that you do not mention: "Surface area"
You will have to allow remote connections in this configuration tool. That is for each SQL Server 2005 service that you are using.
HTH
Thomas Ivarsson
|||Couple of things.
One. Make sure you use SQL Configuration Manager to change serivce logon account for both SQL Browser and for Analysis Server.
Second. Take a look at the connectivity troubleshooting guide http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
The Surface Afrea Conf tool returns the following error:
TITLE: Surface Area Configuration
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK
|||I am using the SQL Config Mgr to change the user id's. BTW this is sometimes a bit crooked, and I still need to change the Service Account in the Service Manager as well.
Besides, I don't really think the problem's in there. Setup should set the correct permissions for the Logon Account.
Thanks for pointing me to your post on SQLJunkies. I've used it before.
|||I've narrowed it don a bit. It seems only the Service Account used for SQL browser has to be in the Local Admins group.Permissions for SSAS Service Account?
Hi All,
Please help with this.
I'm running a server with Windows Server 2003 R2 Enterprise x64 Edition.
On the box I've performed one named instance installation of SSAS.
I've installed SP1 as well.
There's no firewall running on the machine.
My domain account is in the SSAS Server role.
SSAS Service is running according to SQL Configuration Manager
SQL Browser Service is running according to SQL Configuration Manager
If I run both SSAS and SQL Browser under Local System, everything works OK. But this is not the way I want it, because it's not safe and SSAS is unable to read data from the remote SQL box.
If I change the service account to a domain user account, I can't connect to SSAs anymore. The error message is:
TITLE: Microsoft SQL Server Management Studio
A connection cannot be made to redirector. Ensure that 'SQL Browser' service is running. (Microsoft.AnalysisServices.AdomdClient)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK
I've both set the logon account at setup, using SQL Config Mgr and Service Manager.
Using PortQry I can see nothing's listening on port 2382.
It should work. I'm beginning to think this user account doesn't have sufficient rights.
So I've created two local accounts and used these as service accounts. Same thing, untill I added both accounts to the local administrators group, then everything worked fine again.
What am I doing wrong here? Your suggestions are much appreciated.
Thanks,
Coen
Hello. You have another configuration that you do not mention: "Surface area"
You will have to allow remote connections in this configuration tool. That is for each SQL Server 2005 service that you are using.
HTH
Thomas Ivarsson
|||Couple of things.
One. Make sure you use SQL Configuration Manager to change serivce logon account for both SQL Browser and for Analysis Server.
Second. Take a look at the connectivity troubleshooting guide http://www.sqljunkies.com/WebLog/edwardm/archive/2006/05/26/21447.aspx
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
The Surface Afrea Conf tool returns the following error:
TITLE: Surface Area Configuration
A connection cannot be made. Ensure that the server is running. (Microsoft.AnalysisServices)
ADDITIONAL INFORMATION:
No connection could be made because the target machine actively refused it (System)
BUTTONS:
OK
|||I am using the SQL Config Mgr to change the user id's. BTW this is sometimes a bit crooked, and I still need to change the Service Account in the Service Manager as well.
Besides, I don't really think the problem's in there. Setup should set the correct permissions for the Logon Account.
Thanks for pointing me to your post on SQLJunkies. I've used it before.
|||I've narrowed it don a bit. It seems only the Service Account used for SQL browser has to be in the Local Admins group.Friday, March 9, 2012
Permissions
I just moved a database from our old server to our new box using DTS.
Everything looks like it's there but I can't find out because I can't query
the database! I keep getting:
SELECT permission denied on object 'RESPONSES', database 'EMYST', owner 'dbo'.
I've turned on every permission I can find for the user I'm using in Query
Analyzer but I keep getting this message.
I'm not a DBA (ours left) so I'm kind of clueless about where to look. Any
help would be massively appreciated.
Thanks,
DLIE
DrLostinExcel wrote:
> I just moved a database from our old server to our new box using DTS.
> Everything looks like it's there but I can't find out because I can't
> query the database! I keep getting:
> SELECT permission denied on object 'RESPONSES', database 'EMYST',
> owner 'dbo'. I've turned on every permission I can find for the user
> I'm using in Query Analyzer but I keep getting this message.
> I'm not a DBA (ours left) so I'm kind of clueless about where to
> look. Any help would be massively appreciated.
> Thanks,
> DLIE
You might want to script out object permissions and logins from the
original server using SQL Enterprise Manager to get them in sync. The
error indicates that the user ID you are using to connect to the server
does not have rights to select from the table in question.
To get through this particular issue for this table, you can log into
the server with a user with sufficient rights and issue a grant on the
table:
grant select on table to username
But I suspect there are larger issues at work here. From SQL EM, right
click on the database - All Tasks - Generate SQL Script. Uncheck
everything on Formatting tab and check Script Database users and Role,
check Script SQL Server Logins, and check Script Object-Level
Permissions from the Options tab. Generate the script, look it over, and
then run it on the new server.
David Gugick
Imceda Software
www.imceda.com
|||Hi
Here are some links to articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897
Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp
Utility to map logins to users http://www.support.microsoft.com/?id=168001
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
Hope this helps
John
"David Gugick" wrote:
> DrLostinExcel wrote:
> You might want to script out object permissions and logins from the
> original server using SQL Enterprise Manager to get them in sync. The
> error indicates that the user ID you are using to connect to the server
> does not have rights to select from the table in question.
> To get through this particular issue for this table, you can log into
> the server with a user with sufficient rights and issue a grant on the
> table:
> grant select on table to username
> But I suspect there are larger issues at work here. From SQL EM, right
> click on the database - All Tasks - Generate SQL Script. Uncheck
> everything on Formatting tab and check Script Database users and Role,
> check Script SQL Server Logins, and check Script Object-Level
> Permissions from the Options tab. Generate the script, look it over, and
> then run it on the new server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Everything looks like it's there but I can't find out because I can't query
the database! I keep getting:
SELECT permission denied on object 'RESPONSES', database 'EMYST', owner 'dbo'.
I've turned on every permission I can find for the user I'm using in Query
Analyzer but I keep getting this message.
I'm not a DBA (ours left) so I'm kind of clueless about where to look. Any
help would be massively appreciated.
Thanks,
DLIE
DrLostinExcel wrote:
> I just moved a database from our old server to our new box using DTS.
> Everything looks like it's there but I can't find out because I can't
> query the database! I keep getting:
> SELECT permission denied on object 'RESPONSES', database 'EMYST',
> owner 'dbo'. I've turned on every permission I can find for the user
> I'm using in Query Analyzer but I keep getting this message.
> I'm not a DBA (ours left) so I'm kind of clueless about where to
> look. Any help would be massively appreciated.
> Thanks,
> DLIE
You might want to script out object permissions and logins from the
original server using SQL Enterprise Manager to get them in sync. The
error indicates that the user ID you are using to connect to the server
does not have rights to select from the table in question.
To get through this particular issue for this table, you can log into
the server with a user with sufficient rights and issue a grant on the
table:
grant select on table to username
But I suspect there are larger issues at work here. From SQL EM, right
click on the database - All Tasks - Generate SQL Script. Uncheck
everything on Formatting tab and check Script Database users and Role,
check Script SQL Server Logins, and check Script Object-Level
Permissions from the Options tab. Generate the script, look it over, and
then run it on the new server.
David Gugick
Imceda Software
www.imceda.com
|||Hi
Here are some links to articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897
Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp
Utility to map logins to users http://www.support.microsoft.com/?id=168001
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
Hope this helps
John
"David Gugick" wrote:
> DrLostinExcel wrote:
> You might want to script out object permissions and logins from the
> original server using SQL Enterprise Manager to get them in sync. The
> error indicates that the user ID you are using to connect to the server
> does not have rights to select from the table in question.
> To get through this particular issue for this table, you can log into
> the server with a user with sufficient rights and issue a grant on the
> table:
> grant select on table to username
> But I suspect there are larger issues at work here. From SQL EM, right
> click on the database - All Tasks - Generate SQL Script. Uncheck
> everything on Formatting tab and check Script Database users and Role,
> check Script SQL Server Logins, and check Script Object-Level
> Permissions from the Options tab. Generate the script, look it over, and
> then run it on the new server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Permissions
I just moved a database from our old server to our new box using DTS.
Everything looks like it's there but I can't find out because I can't query
the database! I keep getting:
SELECT permission denied on object 'RESPONSES', database 'EMYST', owner 'dbo
'.
I've turned on every permission I can find for the user I'm using in Query
Analyzer but I keep getting this message.
I'm not a DBA (ours left) so I'm kind of clueless about where to look. Any
help would be massively appreciated.
Thanks,
DLIEDrLostinExcel wrote:
> I just moved a database from our old server to our new box using DTS.
> Everything looks like it's there but I can't find out because I can't
> query the database! I keep getting:
> SELECT permission denied on object 'RESPONSES', database 'EMYST',
> owner 'dbo'. I've turned on every permission I can find for the user
> I'm using in Query Analyzer but I keep getting this message.
> I'm not a DBA (ours left) so I'm kind of clueless about where to
> look. Any help would be massively appreciated.
> Thanks,
> DLIE
You might want to script out object permissions and logins from the
original server using SQL Enterprise Manager to get them in sync. The
error indicates that the user ID you are using to connect to the server
does not have rights to select from the table in question.
To get through this particular issue for this table, you can log into
the server with a user with sufficient rights and issue a grant on the
table:
grant select on table to username
But I suspect there are larger issues at work here. From SQL EM, right
click on the database - All Tasks - Generate SQL Script. Uncheck
everything on Formatting tab and check Script Database users and Role,
check Script SQL Server Logins, and check Script Object-Level
Permissions from the Options tab. Generate the script, look it over, and
then run it on the new server.
David Gugick
Imceda Software
www.imceda.com|||Hi
Here are some links to articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897
Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp
Utility to map logins to users http://www.support.microsoft.com/?id=168001
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
Hope this helps
John
"David Gugick" wrote:
> DrLostinExcel wrote:
> You might want to script out object permissions and logins from the
> original server using SQL Enterprise Manager to get them in sync. The
> error indicates that the user ID you are using to connect to the server
> does not have rights to select from the table in question.
> To get through this particular issue for this table, you can log into
> the server with a user with sufficient rights and issue a grant on the
> table:
> grant select on table to username
> But I suspect there are larger issues at work here. From SQL EM, right
> click on the database - All Tasks - Generate SQL Script. Uncheck
> everything on Formatting tab and check Script Database users and Role,
> check Script SQL Server Logins, and check Script Object-Level
> Permissions from the Options tab. Generate the script, look it over, and
> then run it on the new server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Everything looks like it's there but I can't find out because I can't query
the database! I keep getting:
SELECT permission denied on object 'RESPONSES', database 'EMYST', owner 'dbo
'.
I've turned on every permission I can find for the user I'm using in Query
Analyzer but I keep getting this message.
I'm not a DBA (ours left) so I'm kind of clueless about where to look. Any
help would be massively appreciated.
Thanks,
DLIEDrLostinExcel wrote:
> I just moved a database from our old server to our new box using DTS.
> Everything looks like it's there but I can't find out because I can't
> query the database! I keep getting:
> SELECT permission denied on object 'RESPONSES', database 'EMYST',
> owner 'dbo'. I've turned on every permission I can find for the user
> I'm using in Query Analyzer but I keep getting this message.
> I'm not a DBA (ours left) so I'm kind of clueless about where to
> look. Any help would be massively appreciated.
> Thanks,
> DLIE
You might want to script out object permissions and logins from the
original server using SQL Enterprise Manager to get them in sync. The
error indicates that the user ID you are using to connect to the server
does not have rights to select from the table in question.
To get through this particular issue for this table, you can log into
the server with a user with sufficient rights and issue a grant on the
table:
grant select on table to username
But I suspect there are larger issues at work here. From SQL EM, right
click on the database - All Tasks - Generate SQL Script. Uncheck
everything on Formatting tab and check Script Database users and Role,
check Script SQL Server Logins, and check Script Object-Level
Permissions from the Options tab. Generate the script, look it over, and
then run it on the new server.
David Gugick
Imceda Software
www.imceda.com|||Hi
Here are some links to articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897
Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp
Utility to map logins to users http://www.support.microsoft.com/?id=168001
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872
How to Resolve Permission Issues When a Database Is Moved Between SQL Server
s
Hope this helps
John
"David Gugick" wrote:
> DrLostinExcel wrote:
> You might want to script out object permissions and logins from the
> original server using SQL Enterprise Manager to get them in sync. The
> error indicates that the user ID you are using to connect to the server
> does not have rights to select from the table in question.
> To get through this particular issue for this table, you can log into
> the server with a user with sufficient rights and issue a grant on the
> table:
> grant select on table to username
> But I suspect there are larger issues at work here. From SQL EM, right
> click on the database - All Tasks - Generate SQL Script. Uncheck
> everything on Formatting tab and check Script Database users and Role,
> check Script SQL Server Logins, and check Script Object-Level
> Permissions from the Options tab. Generate the script, look it over, and
> then run it on the new server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Permissions
I just moved a database from our old server to our new box using DTS.
Everything looks like it's there but I can't find out because I can't query
the database! I keep getting:
SELECT permission denied on object 'RESPONSES', database 'EMYST', owner 'dbo'.
I've turned on every permission I can find for the user I'm using in Query
Analyzer but I keep getting this message.
I'm not a DBA (ours left) so I'm kind of clueless about where to look. Any
help would be massively appreciated.
Thanks,
DLIEDrLostinExcel wrote:
> I just moved a database from our old server to our new box using DTS.
> Everything looks like it's there but I can't find out because I can't
> query the database! I keep getting:
> SELECT permission denied on object 'RESPONSES', database 'EMYST',
> owner 'dbo'. I've turned on every permission I can find for the user
> I'm using in Query Analyzer but I keep getting this message.
> I'm not a DBA (ours left) so I'm kind of clueless about where to
> look. Any help would be massively appreciated.
> Thanks,
> DLIE
You might want to script out object permissions and logins from the
original server using SQL Enterprise Manager to get them in sync. The
error indicates that the user ID you are using to connect to the server
does not have rights to select from the table in question.
To get through this particular issue for this table, you can log into
the server with a user with sufficient rights and issue a grant on the
table:
grant select on table to username
But I suspect there are larger issues at work here. From SQL EM, right
click on the database - All Tasks - Generate SQL Script. Uncheck
everything on Formatting tab and check Script Database users and Role,
check Script SQL Server Logins, and check Script Object-Level
Permissions from the Options tab. Generate the script, look it over, and
then run it on the new server.
David Gugick
Imceda Software
www.imceda.com|||Hi
Here are some links to articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897
Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp
Utility to map logins to users http://www.support.microsoft.com/?id=168001
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
Hope this helps
John
"David Gugick" wrote:
> DrLostinExcel wrote:
> > I just moved a database from our old server to our new box using DTS.
> > Everything looks like it's there but I can't find out because I can't
> > query the database! I keep getting:
> > SELECT permission denied on object 'RESPONSES', database 'EMYST',
> > owner 'dbo'. I've turned on every permission I can find for the user
> > I'm using in Query Analyzer but I keep getting this message.
> > I'm not a DBA (ours left) so I'm kind of clueless about where to
> > look. Any help would be massively appreciated.
> > Thanks,
> >
> > DLIE
> You might want to script out object permissions and logins from the
> original server using SQL Enterprise Manager to get them in sync. The
> error indicates that the user ID you are using to connect to the server
> does not have rights to select from the table in question.
> To get through this particular issue for this table, you can log into
> the server with a user with sufficient rights and issue a grant on the
> table:
> grant select on table to username
> But I suspect there are larger issues at work here. From SQL EM, right
> click on the database - All Tasks - Generate SQL Script. Uncheck
> everything on Formatting tab and check Script Database users and Role,
> check Script SQL Server Logins, and check Script Object-Level
> Permissions from the Options tab. Generate the script, look it over, and
> then run it on the new server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Everything looks like it's there but I can't find out because I can't query
the database! I keep getting:
SELECT permission denied on object 'RESPONSES', database 'EMYST', owner 'dbo'.
I've turned on every permission I can find for the user I'm using in Query
Analyzer but I keep getting this message.
I'm not a DBA (ours left) so I'm kind of clueless about where to look. Any
help would be massively appreciated.
Thanks,
DLIEDrLostinExcel wrote:
> I just moved a database from our old server to our new box using DTS.
> Everything looks like it's there but I can't find out because I can't
> query the database! I keep getting:
> SELECT permission denied on object 'RESPONSES', database 'EMYST',
> owner 'dbo'. I've turned on every permission I can find for the user
> I'm using in Query Analyzer but I keep getting this message.
> I'm not a DBA (ours left) so I'm kind of clueless about where to
> look. Any help would be massively appreciated.
> Thanks,
> DLIE
You might want to script out object permissions and logins from the
original server using SQL Enterprise Manager to get them in sync. The
error indicates that the user ID you are using to connect to the server
does not have rights to select from the table in question.
To get through this particular issue for this table, you can log into
the server with a user with sufficient rights and issue a grant on the
table:
grant select on table to username
But I suspect there are larger issues at work here. From SQL EM, right
click on the database - All Tasks - Generate SQL Script. Uncheck
everything on Formatting tab and check Script Database users and Role,
check Script SQL Server Logins, and check Script Object-Level
Permissions from the Options tab. Generate the script, look it over, and
then run it on the new server.
David Gugick
Imceda Software
www.imceda.com|||Hi
Here are some links to articles that should help you resolve your problem.
http://www.support.microsoft.com/?id=246133
How To Transfer Logins and Passwords Between SQL Servers
http://www.support.microsoft.com/?id=298897
Mapping Logins & SIDs after a Restore
http://www.dbmaint.com/SyncSqlLogins.asp
Utility to map logins to users http://www.support.microsoft.com/?id=168001
User Logon and/or Permission Errors After Restoring Dump
http://www.support.microsoft.com/?id=240872
How to Resolve Permission Issues When a Database Is Moved Between SQL Servers
Hope this helps
John
"David Gugick" wrote:
> DrLostinExcel wrote:
> > I just moved a database from our old server to our new box using DTS.
> > Everything looks like it's there but I can't find out because I can't
> > query the database! I keep getting:
> > SELECT permission denied on object 'RESPONSES', database 'EMYST',
> > owner 'dbo'. I've turned on every permission I can find for the user
> > I'm using in Query Analyzer but I keep getting this message.
> > I'm not a DBA (ours left) so I'm kind of clueless about where to
> > look. Any help would be massively appreciated.
> > Thanks,
> >
> > DLIE
> You might want to script out object permissions and logins from the
> original server using SQL Enterprise Manager to get them in sync. The
> error indicates that the user ID you are using to connect to the server
> does not have rights to select from the table in question.
> To get through this particular issue for this table, you can log into
> the server with a user with sufficient rights and issue a grant on the
> table:
> grant select on table to username
> But I suspect there are larger issues at work here. From SQL EM, right
> click on the database - All Tasks - Generate SQL Script. Uncheck
> everything on Formatting tab and check Script Database users and Role,
> check Script SQL Server Logins, and check Script Object-Level
> Permissions from the Options tab. Generate the script, look it over, and
> then run it on the new server.
>
> --
> David Gugick
> Imceda Software
> www.imceda.com
>
Wednesday, March 7, 2012
Permission to run DBCC DROPCLEANBUFFERS
Were using SQL Server 2000.
Whilst the devevelopers have reasonably good access to do most things on the
Dev box, we are not granted SA rights.
For performance tuning of queries, I need to be able to run DBCC
DROPCLEANBUFFERS but apparently you need to be SA to do this.
Does anybody know how we can get around this so the DBA's can affectivly
give me these permissions without making me SA.
Any help would be great.
Thanks,
JoeI'm pretty sure that only sysadmin role members can execute DBCC
DROPCLEANBUFFERS. That's the requirement in SQL 2005 so the same probably
applies to SQL 2000.
Hope this helps.
Dan Guzman
SQL Server MVP
"KCSL" <KCSL@.discussions.microsoft.com> wrote in message
news:AE187C22-F0DC-44C9-902B-D87C14CCD8B6@.microsoft.com...
> Were using SQL Server 2000.
> Whilst the devevelopers have reasonably good access to do most things on
> the
> Dev box, we are not granted SA rights.
> For performance tuning of queries, I need to be able to run DBCC
> DROPCLEANBUFFERS but apparently you need to be SA to do this.
> Does anybody know how we can get around this so the DBA's can affectivly
> give me these permissions without making me SA.
> Any help would be great.
> Thanks,
> Joe
>|||Not possible. You have to be an member of the sysadmin role to issue that
command. There is a reason for that. You are going to purge every buffer
in the system which will force SQL Server to read everything back off disk.
Only a sysadmin should have the authority to make that decision.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"KCSL" <KCSL@.discussions.microsoft.com> wrote in message
news:AE187C22-F0DC-44C9-902B-D87C14CCD8B6@.microsoft.com...
> Were using SQL Server 2000.
> Whilst the devevelopers have reasonably good access to do most things on
> the
> Dev box, we are not granted SA rights.
> For performance tuning of queries, I need to be able to run DBCC
> DROPCLEANBUFFERS but apparently you need to be SA to do this.
> Does anybody know how we can get around this so the DBA's can affectivly
> give me these permissions without making me SA.
> Any help would be great.
> Thanks,
> Joe
>|||"KCSL" <KCSL@.discussions.microsoft.com> wrote in message
news:AE187C22-F0DC-44C9-902B-D87C14CCD8B6@.microsoft.com...
> Were using SQL Server 2000.
> Whilst the devevelopers have reasonably good access to do most things on
> the
> Dev box, we are not granted SA rights.
> For performance tuning of queries, I need to be able to run DBCC
> DROPCLEANBUFFERS but apparently you need to be SA to do this.
> Does anybody know how we can get around this so the DBA's can affectivly
> give me these permissions without making me SA.
>
You shouldn't be using DBCC DROPCLEANBUFFERS for performance tuning.
SET STATISTICS IO ON
SET STATISTICS TIME ON
Give you better information. With the large memory sizes of servers, you
never have purged buffers, and your query performance in that situration is
not meaningful. To tune queries the most important metric is amount of
logical IO. You can measure that on production systems or test systems, and
it is very, very highly correlated with elapsed time and CPU utilization.
If you minimize logical IO, you will minimize query cost.
David
Whilst the devevelopers have reasonably good access to do most things on the
Dev box, we are not granted SA rights.
For performance tuning of queries, I need to be able to run DBCC
DROPCLEANBUFFERS but apparently you need to be SA to do this.
Does anybody know how we can get around this so the DBA's can affectivly
give me these permissions without making me SA.
Any help would be great.
Thanks,
JoeI'm pretty sure that only sysadmin role members can execute DBCC
DROPCLEANBUFFERS. That's the requirement in SQL 2005 so the same probably
applies to SQL 2000.
Hope this helps.
Dan Guzman
SQL Server MVP
"KCSL" <KCSL@.discussions.microsoft.com> wrote in message
news:AE187C22-F0DC-44C9-902B-D87C14CCD8B6@.microsoft.com...
> Were using SQL Server 2000.
> Whilst the devevelopers have reasonably good access to do most things on
> the
> Dev box, we are not granted SA rights.
> For performance tuning of queries, I need to be able to run DBCC
> DROPCLEANBUFFERS but apparently you need to be SA to do this.
> Does anybody know how we can get around this so the DBA's can affectivly
> give me these permissions without making me SA.
> Any help would be great.
> Thanks,
> Joe
>|||Not possible. You have to be an member of the sysadmin role to issue that
command. There is a reason for that. You are going to purge every buffer
in the system which will force SQL Server to read everything back off disk.
Only a sysadmin should have the authority to make that decision.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"KCSL" <KCSL@.discussions.microsoft.com> wrote in message
news:AE187C22-F0DC-44C9-902B-D87C14CCD8B6@.microsoft.com...
> Were using SQL Server 2000.
> Whilst the devevelopers have reasonably good access to do most things on
> the
> Dev box, we are not granted SA rights.
> For performance tuning of queries, I need to be able to run DBCC
> DROPCLEANBUFFERS but apparently you need to be SA to do this.
> Does anybody know how we can get around this so the DBA's can affectivly
> give me these permissions without making me SA.
> Any help would be great.
> Thanks,
> Joe
>|||"KCSL" <KCSL@.discussions.microsoft.com> wrote in message
news:AE187C22-F0DC-44C9-902B-D87C14CCD8B6@.microsoft.com...
> Were using SQL Server 2000.
> Whilst the devevelopers have reasonably good access to do most things on
> the
> Dev box, we are not granted SA rights.
> For performance tuning of queries, I need to be able to run DBCC
> DROPCLEANBUFFERS but apparently you need to be SA to do this.
> Does anybody know how we can get around this so the DBA's can affectivly
> give me these permissions without making me SA.
>
You shouldn't be using DBCC DROPCLEANBUFFERS for performance tuning.
SET STATISTICS IO ON
SET STATISTICS TIME ON
Give you better information. With the large memory sizes of servers, you
never have purged buffers, and your query performance in that situration is
not meaningful. To tune queries the most important metric is amount of
logical IO. You can measure that on production systems or test systems, and
it is very, very highly correlated with elapsed time and CPU utilization.
If you minimize logical IO, you will minimize query cost.
David
Saturday, February 25, 2012
Permission Issues On REPL folder
I'm replicating a database from a SQL server in our DMZ to a server in the
internal network. There is only a one way trust from internal box to
external box (external box cannot see internal). I setup DMZ database as
Publisher and Distributor. The internal box can only pull. When I initiate
a PULL I get a permission's error on REPL folder: The process could not
read file
'\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch' due to OS error 1326.
Any thoughts on how to resolve this permission issue.
thanks
rob
from your internal network on your subscriber can you ping ServerName your
publisher by the netbios name? If not make an entry in the hosts file.
Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
> I'm replicating a database from a SQL server in our DMZ to a server in the
> internal network. There is only a one way trust from internal box to
> external box (external box cannot see internal). I setup DMZ database as
> Publisher and Distributor. The internal box can only pull. When I
> initiate
> a PULL I get a permission's error on REPL folder: The process could not
> read file
> '\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch'
> due to OS error 1326.
> Any thoughts on how to resolve this permission issue.
> thanks
> rob
>
|||I can ping server with netbios name. I can access share folder using
\\servername\share\ at cmd prompt.
When I run "net view" at the xp_cmdshell I get "System error 5 has occurred"
and "Access is denied"
When I run "dir" at xp_cmdshell I get "Logon failure: unknown user name or
bad password."
Its definitely user access error. I can get the two servers to communicate
in windows, but not sure how to pass security thru to another sql server on
a separate network (DMZ).
thanks again
rob
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OiaaERKHGHA.3904@.TK2MSFTNGP10.phx.gbl...
> from your internal network on your subscriber can you ping ServerName your
> publisher by the netbios name? If not make an entry in the hosts file.
> Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
> about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
>
internal network. There is only a one way trust from internal box to
external box (external box cannot see internal). I setup DMZ database as
Publisher and Distributor. The internal box can only pull. When I initiate
a PULL I get a permission's error on REPL folder: The process could not
read file
'\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch' due to OS error 1326.
Any thoughts on how to resolve this permission issue.
thanks
rob
from your internal network on your subscriber can you ping ServerName your
publisher by the netbios name? If not make an entry in the hosts file.
Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
> I'm replicating a database from a SQL server in our DMZ to a server in the
> internal network. There is only a one way trust from internal box to
> external box (external box cannot see internal). I setup DMZ database as
> Publisher and Distributor. The internal box can only pull. When I
> initiate
> a PULL I get a permission's error on REPL folder: The process could not
> read file
> '\\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\ 20060117141721\SPECIAL_PRICES_1.sch'
> due to OS error 1326.
> Any thoughts on how to resolve this permission issue.
> thanks
> rob
>
|||I can ping server with netbios name. I can access share folder using
\\servername\share\ at cmd prompt.
When I run "net view" at the xp_cmdshell I get "System error 5 has occurred"
and "Access is denied"
When I run "dir" at xp_cmdshell I get "Logon failure: unknown user name or
bad password."
Its definitely user access error. I can get the two servers to communicate
in windows, but not sure how to pass security thru to another sql server on
a separate network (DMZ).
thanks again
rob
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OiaaERKHGHA.3904@.TK2MSFTNGP10.phx.gbl...
> from your internal network on your subscriber can you ping ServerName your
> publisher by the netbios name? If not make an entry in the hosts file.
> Then using qa can you issue a xp_cmdshell 'net view \\ServerName' and how
> about a 'dir \\ServerName\REPLDATA\unc\ServerName_SQLDB_TRANS\' ?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:46A6A4E8-0A5F-487F-9DFA-D7E01E02CFBB@.microsoft.com...
>
Monday, February 20, 2012
permission denied in accessing SQl 2000
Good day,
Is there anyone could help me, I'm moving our database from old machine to a new one and Iused DTS to move it the new box. Somehow it was moved but I'm still having probelm with my front-end application when I'm trying to open it the error is something like this.
"3704-Operation is not allowed when the object is closed.
an error occurred in Cal_General.CheckDBVSN.Global Error:
-2147217911 -SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
underlying Errors:
Error #-217217911
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.
(Source MIcrosoft OLE Provider for SQL Server)
(SQL State: 42000)
(NativeError:229)
No Help file available."
Hope someone could resolve my query.
Thanks,
The databases may have been moved but not the permissions. If you have a security script with the scripted permissions you should execute it on the new server. The error indicates that the objects exists but the connecting user has no permissions querying them.Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
Hi Jens,
I already checked the permission of the table and selected those admin rights to make sure that I could be able to use the tabel but still the same proble I get. It is hard for me to work with the SQL co'z my boss assigned my from Sys admin to DB admin I'm really have a hard time to solve the problem.
Vinci
|||OK, having dbadmin rights should be eough in your case to administer the permissions needed. Did you make sure that the user has permissions accessing the following objects:SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.
if the object are views, make sure that the underlying tables are also accessible to the user (if the ownership chain is broken)
Jens K. Suessmeyer
http://www.sqlserver2005.de
permission denied in accessing SQl 2000
Good day,
Is there anyone could help me, I'm moving our database from old machine to a new one and Iused DTS to move it the new box. Somehow it was moved but I'm still having probelm with my front-end application when I'm trying to open it the error is something like this.
"3704-Operation is not allowed when the object is closed.
an error occurred in Cal_General.CheckDBVSN.Global Error:
-2147217911 -SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
underlying Errors:
Error #-217217911
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.
(Source MIcrosoft OLE Provider for SQL Server)
(SQL State: 42000)
(NativeError:229)
No Help file available."
Hope someone could resolve my query.
Thanks,
The databases may have been moved but not the permissions. If you have a security script with the scripted permissions you should execute it on the new server. The error indicates that the objects exists but the connecting user has no permissions querying them.Jens K. Suessmeyer
http://www.sqlserver2005.de
|||
Hi Jens,
I already checked the permission of the table and selected those admin rights to make sure that I could be able to use the tabel but still the same proble I get. It is hard for me to work with the SQL co'z my boss assigned my from Sys admin to DB admin I'm really have a hard time to solve the problem.
Vinci
|||OK, having dbadmin rights should be eough in your case to administer the permissions needed. Did you make sure that the user has permissions accessing the following objects:SELECT permission denied on object 'Global_config', Database 'dbase1', owner "App1.
SELECT permission denied on object 'Global_config' database 'calsql1', owner "App1'.
if the object are views, make sure that the underlying tables are also accessible to the user (if the ownership chain is broken)
Jens K. Suessmeyer
http://www.sqlserver2005.de
Permission Denied Error
I am an issue running reports through a Netscreen (Juniper)
box and have found nothing on Juniper's website that addresses the issue. I
can access the Report Manager easily and enter parameters for a report.
However when I click on the View Report button I get a permission denied
error when executing the following Miscrosoft scipt:
function LoadToolbarFrame()
{
if (frames["oTbDMRepFrame"].location.href != tbDMRepFrameUrl ||
!IsIEBrowser())
frames["oTbDMRepFrame"].location.replace(tbDMRepFrameUrl);
}
I have been working on this for quite some time and have not found a
solution. I would appreciate any ideas and solutions.What is your ReportServer URL in your config files? Is that different than
the URL you are typing in your browser? If so, you may be running into a
cross-domain scripting error.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:53751243-0BEF-4405-A154-DBBF3218635B@.microsoft.com...
>I am an issue running reports through a Netscreen (Juniper)
> box and have found nothing on Juniper's website that addresses the issue.
> I
> can access the Report Manager easily and enter parameters for a report.
> However when I click on the View Report button I get a permission denied
> error when executing the following Miscrosoft scipt:
> function LoadToolbarFrame()
> {
> if (frames["oTbDMRepFrame"].location.href != tbDMRepFrameUrl ||
> !IsIEBrowser())
> frames["oTbDMRepFrame"].location.replace(tbDMRepFrameUrl);
> }
> I have been working on this for quite some time and have not found a
> solution. I would appreciate any ideas and solutions.
>
box and have found nothing on Juniper's website that addresses the issue. I
can access the Report Manager easily and enter parameters for a report.
However when I click on the View Report button I get a permission denied
error when executing the following Miscrosoft scipt:
function LoadToolbarFrame()
{
if (frames["oTbDMRepFrame"].location.href != tbDMRepFrameUrl ||
!IsIEBrowser())
frames["oTbDMRepFrame"].location.replace(tbDMRepFrameUrl);
}
I have been working on this for quite some time and have not found a
solution. I would appreciate any ideas and solutions.What is your ReportServer URL in your config files? Is that different than
the URL you are typing in your browser? If so, you may be running into a
cross-domain scripting error.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:53751243-0BEF-4405-A154-DBBF3218635B@.microsoft.com...
>I am an issue running reports through a Netscreen (Juniper)
> box and have found nothing on Juniper's website that addresses the issue.
> I
> can access the Report Manager easily and enter parameters for a report.
> However when I click on the View Report button I get a permission denied
> error when executing the following Miscrosoft scipt:
> function LoadToolbarFrame()
> {
> if (frames["oTbDMRepFrame"].location.href != tbDMRepFrameUrl ||
> !IsIEBrowser())
> frames["oTbDMRepFrame"].location.replace(tbDMRepFrameUrl);
> }
> I have been working on this for quite some time and have not found a
> solution. I would appreciate any ideas and solutions.
>
Subscribe to:
Posts (Atom)