I new to SQL 2005 and have couple of questions regarding configuring the user. Let me start by saying what I need to be achieved.
1. Create a new user which will be user by couple of people to create and execute stored procedures
2. Deny all permissions for this user to access data from certain tables.
3. Configure the role and permissions for this user so that the above two is possible.
I was able to do the first two steps and when the users uses a query, ( select * from 'that table' ) the result in a permissions error. Also that user cannot view the table in SQL manager
The problem now is that that user can create a stored procedure that has the SQL statement Select * from 'that table' and execute the stored procedure to view the table.
The reason I created this user is to allow a team in the company to create stored procedures for Crystal. In theory he should be able to create stored procedures but not get any data from the denied tables. How can I achieve this?
I am trying to resolve this issue for a while now and any help is greatly appreciated.
This is my first time to deploy an asp.net2 web site. Everything is working fine on my local computer but when i published the web site on a remote computer i get the error "Failed to generate a user instance of SQL Server due to failure in retrieving the user's local application data path. Please make sure the user has a local user profile on the computer. The connection will be closed" (only in pages that try to access the database) Help pleaseee
We have recently added 1GB Ram to our systems and now we are trying to optimally configure 2GB of RAM for SS6.5 SP4 and we are getting the fllowing error INFREQUENTLY
"Not enough memory for pss allocation"
We have to restart the SQL server/ (recover databases) to get out of this. Since it is a heavily loaded production environment you can imagine the impact!!.
There is a recommendation to reduce the memory or stack size parameters ref:Q160683!!
Question
1. I would like to know if anyone has got around a similar problem, and how. 2. As in NT Virtual Memory Manager AUTOMATICALLY brokers the allocation of physical memory between the requesting applications (e.g. sqlsrvr.exe) and the page file and no application can write directly to RAM, what does the memory parameter in SQL config control? Also then how is the above KB article relevant?
Hi all, I have a question regarding SQL caching. I want to use SQL caching for my pages.I've gone through http://msdn2.microsoft.com/en-us/library/e3w8402y(VS.80).aspx article on msdn, where in step by step procedure is explained for this. But I have a slightly different situation. In the article, we need to configure our application from web.config by following... <!-- caching section group --><caching> <sqlCacheDependency enabled = "true" pollTime = "1000" > <databases> <add name="Northwind" connectionStringName="NorthwindConnectionString1" pollTime = "1000" /> </databases> </sqlCacheDependency></caching>
Where in "NorthwindConnectionString1" is the SQLdatasource connection string. But I'm not using SQLDatasource, and have my own classes to build a connection datasource and get a dataset, and then bind it to my control.So in this case what should I write for the above "connectionstring" attribute. My connection string is in web.config only with a section defined. and in my application i'm reading from web.fing only.The connection section i'm using is as follows... <ConnSettings> <add key="ConnString" value="server=serverName;database=dbName;uid=dbuser;Pwd=password"/> </ConnSettings> I want to know how to configure my sql cache in this situation.
Hi When I try to configure a SQL datasource and I use a Microsoft SQL Server datasource I get a blank drop down list for server name. My aspnetdb is available in SQL Server 2005 and I can log into it through management studio, and the service is started. I am also using Vista Ultimate. Is there any other configuration I need to do for Visual Studio 2008 to see the SQL Server instance? Thanks Kwis
Hi all, I want to configure my SQL mail. I am able to configure SQL mail when i run the SQLAgent and SQL Server services under domain account for which Mail box was created in MS Exchange server. Also it works fine. But i want to Configure SQL mail without using Domain account (dont want to run services under domain account due to security reasons).
Anybody know how to Configure SQL mail without using domain account or is it possible to configure like that? Your suggestions are highly appreciated. thanks in advance. regards..
I am fairly new to SSRS. I want to install SSRS on my local system which has OS of Win XP sp2 (not a server). I have installed SQL Server instance on this box. Can any body tell if i need Win Server 2000 or 2003 OS to install SSRS or can i use Win XP, if so please give some guidelines.
Hi All,My question is that can I configure SQL MAIL, if my EXCHANGESERVER is on different domain and my SQL is running on differentdomain.Can anyone guide me for this because I googled a lotwithout any result.I am using SQL SERVER 2000 Enterprise Edition with service pack 3.and MICROSOFT EXCHANGE SERVER 2000.ThanksT.V
Can someone help? I am new to Visual basic programming and have down-loaded Visual Basic Express. I followed the instructions for creating my first database but when I got to making the SQL database I got the following error message. " Generating user instances in SQL server is disabled, use sp_configure "user instances enabled" to generate user instances" Where do I find sp_configure and how do I start it.
While configuring reporting services, in the database setup section, I am entering the instance name connecting to, and the user-id details. On applying the changes, i am getting an error that "Using other edition of database for reporting data sources and/or report server databases is not allowed in this version of Reporting services"
wasnt sure which forum to put this in - so i'll attempt here!
i have been trying to setup SQLMail in SQL2000 but have been having a few problems
i have created an Outlook MAPI profile for SQL to use. i have tested the profile and it is sending emails - the profile was created using the correct user which has local admin privileges and also a domain account
i then assigned this profile to SQLMail within Enterprise manager and clicked Test. this completed successfully stating it was able to start & stop a MAPI session.
so i assumed that was all thats needed??
through Query Analyzer i run a simple test
EXEC xp_sendmail 'Craig.Gamble@<mydomain>.com' 'The DB is full'
i get a success message saying SQL mail sent. but it doesnt appear to send anything? i never recieve anything. The sent items does not contain anything and even when checking the actual Exchange server there is no sign of any mail being sent
i also checked the SQL account permissions to make sure it could access the Exchange Server using the
EXEC xp_cmdshell 'NET USE \EnterpriseIPC$' and again this returned success
so now im stumped!
is there anything else i can check to see where or what its supposedly sending??
I have a site with roles/membership working fine on my local machine, but I am having serious trouble deploying it to a shared host. My hosting provides a sql 2000 database, but the user created for it that I use is not dbo. I am errors when I try to access my site such as Could not find stored procedure 'dbo.aspnet_CheckSchemaVersion'The procedure was created under my user, so it's there, but it's full name ia myusername.aspnet_CheckSchemaVersionHow can I tell the asp.net membership/role provider to use my username instead of dbo when it looks for objects? Thanks
In a web site the user has to choose one out of several sql tables to deal with. He will then be allowed to view the selected table data through a GridView, to insert a new row into and to update a row in the selected table by means of an array of TextBoxes created dynamically on the base of the selected table. I think it is possible to solve the problem fully by properly configuring at run time an SqlDataSource. I have solved the issue of data display by declaring in the code behind within the OnPageLoad sub the following: SqlDataSource1.SelectCommand = "Select * FROM " & selectedTable While for the GridView1 I have added the selected table columns to the columns collection as follows: for i=0 to ColumnCount-1 Dim cac As BoundField = New BoundField cac.HeaderText = HeaderNamesArray(i) cac.DataField = ProductNamesArray(i)Me.GridView1.Columns.Add(cac) next I have difficulty on how to do similar declarations for the insertcommand and update command.
I have several Sql Tables, each containing more than 100 fields, on which I need to perform display operation through GridView, Insert and Update through an array of dynamically created and databound TextBoxes. I would like to use a single page to manage all Sql Tables on the basis of the name of the specific one invoked by the user. In order to achieve that, I need to dynamically configure the SqlDataSource Web Control present on the page for each Sql Table. In particular I need to generate at runtime the InsertCommand and the UpdateCommand. On how to do it I have no idea. Federico
hi all i try all date convertion function that u imagen in my asp.net project to insert a date to sqlserver datetime field but always sql server get the data as "1/1/1900 00:00:00" how can i fix that from sql server plz
I've two servers on which there is the SQL 2000 Server and the IIS 6.0.
I installed the SQL Server Client Tools on web server.
And created the nwind as told in booksonline.
I declared the SQLXML extention and allowed it using IIS 6.
But there is a problem with the virtual directory I created using the tool "Configure XML Support in IIS". Web server doesn't realize it as a virtual directory. Even a jpg or a text file is not served by the IIS.
The web server shows the following error.
ERROR: 500 Internal Server Error HResult: 0x800706f4 Source: Microsoft SQL isapi extension Description: Invalid virtual root settings
When I configure a SQLDataSource control I want the following where clause... WHERE (RegionID = @RegionID AND DistrictID IS NULL AND CampusID IS NULL) OR (DistrictID = @DistrictID AND CampusID IS NULL ) OR(CampusID = @CampusID AND UserRole = 'CampusAdmin') OR (CampusID = @CampusID)but it gets reformated as.... WHERE (RegionID = 'Region10') AND (DistrictID IS NULL) AND (CampusID IS NULL) OR (DistrictID = 2) AND (CampusID IS NULL) OR (CampusID = '999999103') AND (UserRole = 'CampusAdmin') OR (CampusID = '999999103')I don't think these are functionaly equivelant, are they?If not how do I stop the 'wizard' from reformatting the SQL where clause?Thanks
How can I configure my workstation running WIN95 to used the SQL Enterprise Manager from the server end and other utilities. I have installed the client network utility.
Reason to use enterprise manager because I wanted to perform administrative tasks on my workstation and I've installed SQL SERVER 7.0(Standard version with 5 clients)on the WINNT 4.0 server.
Need some help with configuring the Disk Sub system using Raid 10
1. What shud be the disk configuration to have 4000 inserts per second on a RAID 1+0 ? 2. What is the best way to maintain a Hot Stand by Server for a very high OLTP system ( say for a day Trading Database ).
I need to connect my Local Database from SQL Server to the Web Database. I need to know what all things to be done for completing this process. Some one please please help me with this.
Ad if this information is not enough, please do ask me any question regarding this and iam ready to answer them.
One more thing, iam not that familiar with SQL Server 2000 but i can manage to do things.
I am running Microsoft SQL Server 2000 - 8.00.760 Enterprise Editionon Windows 2003 Enterprise Edition (NT 5.2 Build 3790:) I have 4CPUand 8GB of RAM. I have AWE enabled, /pae /3gb switch is on inboot.ini, In my errorlog I have noticed few times error messages as"The SQL Server cannot obtain a LOCK resource at this time. Rerun yourstatement when there are fewer active users or ask the systemadministrator to check the SQL Server lock and memory configuration.." I haven't modified anything in sp_configure 'locks', so i amassuming SQL server is dynamically managing the lock memory. Runningperfmon for few days I observed that Lock Requests/sec are usually few100,000 most of the times and sometimes goes to 2+ million. However Ihaven't seen Lock Memory (KB) going more than 40MB. So i wonder why amI seeing the Error: 1204 in my sql log ? And any advise on how toprevent it.ThanksAswinee
I am learning dotnet thru Microsoft Official Curriculum and I got stuck up at one point. That is I couldn't configure the required databases according to the sql server I have installed and configured. I created a doctors database and while configuring using the below code I couldn't know what is 'ASPNET' in "SELECT @s = @@servername + 'ASPNET'" Also what is 'webuser'
Can someone explain to me what SQLACCOUNT=<domainuser> is or should be set to? I get an error telling me to specify a built in account or give a username domain and password for each service. How do I specify these things I didnt see those in the 1 msdn page that explains this. I asked this before but I still cant figure it out. Thanks.
I have Visual Studio 2005 Professional installed and SQL Server Express installed. In following along with the Microsoft Visual C# Step by Step book, there is a procedure on page xxi to get access to SQL Server Express. At the 2> prompt, however, when I type in go and then press enter, I get the following message:
Msg 15247 Level 16, State 1, Server MyServerNameSQLEXPRESS, Procedure sp_grantlogin, Line 13
User does not have permission to perform this action.
The computer is my own personal computer, with Window Vista installed and no previous versions of MSDE installed. I also have administrator persmissions. The only guidelines in the procedure regarding what to do in the event of an error message is to ensure that the commands were typed in correctly. What could be causing this message, since I do have administrator permissions?
Each time I start of SQL Server Management Studio, I get the following message "Microsoft SQL Server Management Studio configuring environment for first time".
I had a simiiliar message with Visual Studio 2005 and fixed it by setting the setting to look on local disk drive. I cannot find a similiar setting in SQL Server 2005.
We have a number of databases in our company and we recently had to buy a second SQL server. What I would like to do is have both SQL Servers act as failovers for each other. They both are the exact same hardware configuration (dell blades poweredge 1855) and we have a RAID array with Melio clustered file system for our web servers. I haven€™t found any documentation on if this is even possible. Am I completely wrong in thinking this can be done or is there a better solution to spread the load but provide failover support with out buying 2 new machines?
I am using SQL Server 2005 Reporting Services. I have many parameters to pass to the dataset. Is there a way to change the dataset dynamically based on the parameters selected?
Suppose If param1 is selected, I want to use dataset1 and if param 2 is selected. I want to use dataset2 and so on... in my reports.
In the current production environment we have web applications running in asp.net 1.1 (win 2003 server) which uses ASPState DB for the session management. We are in the process of migrating few of the web application in asp.net 2.0. We would like to use the same ASPState DB for both 1.1 and 2.0 applications for maintaining the session.
Problem that we are facing: After going through couple of article for configuring the ASPState DB, We ran the InstallPersistSqlState.sql of .net 2.0 framework (log information is given below). Though the sql has updated the existing ASPState DB with the stored procedure corresponding to asp.net 2.0, still we get the following error
Exception: System.Web.HttpException Message: Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. Please install ASP.NET Session State SQL Server version 2.0 or above.
For certain reasons, we are not able to use aspnetreg_sql.exe for setting up the ASPState database. Is there something that I am missing when I run InstallPersistSqlState.sql alone.
Appreciate your help.
Thanks,
Siva
PS: We ran the InstallPersistSqlState.sql in the local sqlserver2000 (residing in winxp) and it works fine.
Result Log:
Run 'aspnet_regsql.exe -?' for details. --------------------------------------------------
--------------------------------------------------- Completed execution of UninstallPersistSqlState.SQL ---------------------------------------------------
------------------------------------------------ Starting execution of InstallPersistSqlState.SQL ------------------------------------------------
-------------------------------------------------- Note: This file is included for backward compatibility only. You should use aspnet_regsql.exe to install and uninstall SQL session state.
Run 'aspnet_regsql.exe -?' for details. -------------------------------------------------- The CREATE DATABASE process is allocating 0.63 MB on disk 'ASPState'. The CREATE DATABASE process is allocating 0.49 MB on disk 'ASPState_log'. If the job does not exist, an error from msdb.dbo.sp_delete_job is expected. Server: Msg 14262, Level 16, State 1, Procedure sp_verify_job_identifiers, Line 61 The specified @job_name ('ASPState_Job_DeleteExpiredSessions') does not exist.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added.
(1 row(s) affected)
Type added. If the category already exists, an error from msdb.dbo.sp_add_category is expected. Server: Msg 14261, Level 16, State 1, Procedure sp_add_category, Line 32 The specified @name ('[Uncategorized (Local)]') already exists.
------------------------------------------------- Completed execution of InstallPersistSqlState.SQL -------------------------------------------------
I have this problem when i go to http://<servername>/reprots
"The attempt to connect to the report server failed.Check your connection information and that the report server is a compatible "
I dont have any problem viewing the deployed reports from the site, http://<servername>/reportserver. only issue is in viewing report manager.
i have searched the forums and did all the suggested changes required in the config file, by adding the full report url and removing the entries in the virtualdirectory tag. still it didnt help....
I am trying to configure DB mirrorring using the SQLCMD & am getting an error :
Msg 1416, Level 16, State 31, Line 1
Database "Test" is not configured for database mirroring.
All the other steps execute perfectly fine.. the endpoints are created properly... & this fails when I try to give a network server addres with the Port No on the Principal ... I have given it first on the Mirror & that runs fine....
Its fails on the Principal .... also .. when I run the DB Mirrorring Wizard it runs fine .. there is no problem ... want to do it via script .. can some one please help...
Thanks
-- Declare variabled for the Principal, Mirror Servers & the DB that needs to be Mirrorred alongwith the backup path. ETVAR MyPrincipalServer "ServerMY2005" ETVAR MyMirrorServer "ServerMY2005QA" ETVAR Database2Mirror "Test" ETVAR BackupPath "C:" ETVAR Permit "::[Mirroring]"
-- Create the Endpoints on the Principal & the Mirror Server :CONNECT $(MyPrincipalServer) CREATE ENDPOINT [Mirroring] AS TCP (LISTENER_PORT = 5022) FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = REQUIRED ALGORITHM RC4) GO ALTER ENDPOINT [Mirroring] STATE = STARTED GO
:CONNECT $(MyMirrorServer) CREATE ENDPOINT [Mirroring] AS TCP (LISTENER_PORT = 5023) FOR DATA_MIRRORING (ROLE = PARTNER, ENCRYPTION = REQUIRED ALGORITHM RC4) GO ALTER ENDPOINT [Mirroring] STATE = STARTED GO
-- COnnect to the Principal & Set Recvery Model & Take FUll Backup of the DB :CONNECT $(MyPrincipalServer) GRANT CONNECT ON ENDPOINT $(PERMIT) TO [ServiceAccount] go ALTER DATABASE $(Database2Mirror) SET RECOVERY FULL GO CHECKPOINT GO BACKUP DATABASE $(Database2Mirror) TO DISK = '$(BackupPath)$(Database2Mirror).bak' WITH INIT GO
-- Restoring the Backup file to the Mirror Server with NORECOVERY Need to take care of the With MOVE Option. :CONNECT $(MyMirrorServer) GRANT CONNECT ON ENDPOINT $(PERMIT) TO [ServiceAccount] go RESTORE DATABASE $(Database2Mirror) FROM DISK = '$(BackupPath)$(Database2Mirror).bak' with norecovery, move 'Test' to 'C:Test.mdf', move 'Test_log' to 'c:Test.ldf' GO
:CONNECT $(MyPrincipalServer) BACKUP Log $(Database2Mirror) TO DISK = '$(BackupPath)$(Database2Mirror).Trn' GO
-- Restoring the Backup file to the Mirror Server with NORECOVERY Need to take care of the With MOVE Option. :CONNECT $(MyMirrorServer) RESTORE Log $(Database2Mirror) FROM DISK = '$(BackupPath)$(Database2Mirror).Trn' with norecovery --move 'MyTestDB' to 'C:mytesdb.mdf', --move 'MytestDB_log' to 'c:mytestdb.ldg' GO
-- Specify Server Network Address :CONNECT $(MyMirrorServer) Use Master go ALTER DATABASE $(Database2Mirror) SET PARTNER = 'TCP://136.50.85.60:5022'
:CONNECT $(MyPrincipalServer) Use Master go ALTER DATABASE $(Database2Mirror) SET PARTNER = 'TCP://136.50.85.60:5023'
For some reason I can't seem to be able to add SQL databases to VWD
I receive the following error message:
Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
I have reinstalled SQL server but I still have the same problem, I tried tweaking some of the Server configurations without success.
I searched for hours on the web for answers but couldn't find any.
If anyone has any idea what could be the problem please help me.
My OS is Windows XP Professional SP2 IIS is installed.
In Excel it is possible to have a primary and a secondary axis. This would allow for a chart to show to related data sets that have vastly different scales. Is this possible in Reporting Services.
