Hello,
I am migrating my database from Access to SQL Server , The application is in Access too,
I have migrated the application to talk to SQL, I am able to query from database whereas not write to it,
any operation on writing to database gives me ODBC insert on a linked table <tablename> failure.
Can u let me know what needs to be done.
Regards
Vinay Dias
Hi all Im currently going through a ASP.NET book but i just cant get to use the SQL server express databases that come with the code examples in the book. All i can do is read the data but thats about it. I keep on getting the error below whenever i try to alter the data in the databases. I have tried enabling write permissions for the NETWORK SERVICE account for the App_Data folder but i still get the same issue. Im running the web apps with these databases in IIS v5.1 and using Visual web developer express. Im still an ASP.NET novice so please keep the solution to my problem as simple as humanly possible.Thanks in advance all.
Matt
Server Error in '/Chapter06' Application.--------------------------------------------------------------------------------Failed to update database "C:INETPUBWWWROOTCHAPTER06APP_DATAWROXUNITED.MDF" because the database is read-only. 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. Exception Details: System.Data.SqlClient.SqlException: Failed to update database "C:INETPUBWWWROOTCHAPTER06APP_DATAWROXUNITED.MDF" because the database is read-only.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: [SqlException (0x80131904): Failed to update database "C:INETPUBWWWROOTCHAPTER06APP_DATAWROXUNITED.MDF" because the database is read-only.] System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +857338 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +734950 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +149 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +886 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) +415 System.Data.SqlClient.SqlCommand.ExecuteNonQuery() +135 System.Web.UI.WebControls.SqlDataSourceView.ExecuteDbCommand(DbCommand command, DataSourceOperation operation) +401 System.Web.UI.WebControls.SqlDataSourceView.ExecuteUpdate(IDictionary keys, IDictionary values, IDictionary oldValues) +721 System.Web.UI.DataSourceView.Update(IDictionary keys, IDictionary values, IDictionary oldValues, DataSourceViewOperationCallback callback) +78 System.Web.UI.WebControls.DetailsView.HandleUpdate(String commandArg, Boolean causesValidation) +1152 System.Web.UI.WebControls.DetailsView.HandleEvent(EventArgs e, Boolean causesValidation, String validationGroup) +461 System.Web.UI.WebControls.DetailsView.OnBubbleEvent(Object source, EventArgs e) +95 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.DetailsViewRow.OnBubbleEvent(Object source, EventArgs e) +109 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +35 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +115 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +163 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +174 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5102 --------------------------------------------------------------------------------Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
Hi,
I tried to backup the master key by the following syntax :
OPEN MASTER KEY DECRYPTION BY PASSWORD = 'mypassword'
BACKUP MASTER KEY TO FILE = 'c: empmaster' ENCRYPTION BY PASSWORD = 'mypassword'
but it failed and i got the following message:
Cannot write into file 'c: empmaster'. Verify that you have write permissions, that the file path is valid, and that the file does not already exist.
NB: I am using the "sa" user to execute this command.
I know that we have a security permission issue , but where and how ?
Regards,
Tarek Ghazali
SQL Server MVP
I see that a recent related message was posted about built-in accounts.
Anyway, a vendor set up system using SQL 2014. The SQL Server Agent service was running under the 'Local System Account'.
Agent jobs were failing because they couldn't write to a shared folder on the same server. I decided to change the account to a regular privileged domain user. Here is the error message:
Executed as user MYDOMAINSQL2014Agent Cannot open backup device 'EackupMyBackup' Operating system error 5(Access is denied). [SQLSTATE 42000] [Error 3201] BACKUP DATABASE is terminating abnormally [SQLSTATE 42000] [Error 3013]. The step failed
I granted Full Control to that domain user and it still failed. I added 'Everyone' and gave it Full Control and it succeeded.
I understand that the account under which the Agent is running should have Write permissions on the share. However, I must have missed something. The only way I can get this to work is to grant Write or Full Control to Everyone. I absolutely do not want to do that.
Hi there,
Does anyone know a way (a query perhaps?) to determine which logins have write permissions to a specific database on SQL Server 2005? Ive thought about joining sys.syslogins & sys.sysusers but looking at the columns, not sure which one would render me that info.
Any help is appreciated. Many thanks!
Using SQL Server 2k5 sp1, Is there a way to deny users access to a specific column in a table and deny that same column to all stored procedures and views that use that column? I have a password field in a database in which I do not want anyone to have select permissions on (except one user). I denied access in the table itself, however the views still allow for the user to select that password. I know I can go through and set this on a view by view basis, but I am looking for something a little more global.
View 5 Replies View RelatedI have the linked server connection created and works perfectly well. I mean I am able to see the tables while I am on my database.
how do I write a SQL statement to reference the linked server ?
I tried the following:
Select top 100 * from casmpogdbspr1.MPOG_Collations.dbo.AsaClass_Cleaned
Then I get the error message....
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI10" for linked server "casmpogdbspr1" does not contain the table ""MPOG_Collations"."dbo"."AsaClass_Cleaned"". The table either does not exist or the current user does not have permissions on that table.
Hi, How can I read a file on the server and insert it into my SQL Server database. The user is not uploading the file, but it already exists on the Server. Thanks
View 1 Replies View RelatedTake the following tableID Shipment ETA Updated01 123 3/1/04 2/12/0402 123 3/2/04 2/13/0403 123 3/1/04 2/14/0404 154 3/2/04 2/12/0405 456 3/1/04 2/17/0406 456 3/1/04 2/16/0407 456 3/1/04 2/15/04I need a query that will return the 2 most recently updated rows foreach shipment. So the results would look like the following:ID Shipment ETA Updated02 123 3/2/04 2/13/0403 123 3/1/04 2/14/0404 154 3/2/04 2/12/0406 456 3/1/04 2/16/0405 456 3/1/04 2/17/04Thanks,Teknari
View 8 Replies View Relatedi want to check.. Report Server Windows service has Send As permissions on the SMTP server.
how can i do this..
Hello, I have worked with SQL Server 2000 but now we have a requirement where I need to write values from an asp.net form into an XML type in SQL Server 2005.
I have never used XML as a type in SQL Server 2005. How do we write xml into xml type.
For example the structure of XML is something like:
<application>
<applicationID = "value"></applicationID>
<customerName="value></customerName>
</application>
I have to write this kind of XML into the XML type and later retrieve these XML values and populate the form again.
Kindly suggest. Thanks a lot.
I could not write Unicode strings into SQL Server 2000 databse, for example "ÁU", "Tu?n"...
by using oleDbAdapter with InserCommand.
Please give me an instruction.
Thanks so much!
TaiPH - VietNam
Can I write a procedure that should connect to a different SQL server and execute a series of SELECT statement on that SQL SERVER.Reason being is I do not have permission to create procedure on that destination server while I have permission to execute a SELECT statement. Please clarifyThanks,
View 3 Replies View RelatedI connected to SQL Server 7.0 using trusted connection. I have been given permissions in the db_owner group with my NT user id. When I run a query to alter the database for creating a new file group and adding files, there is an error message which says that only members of sysadmin or database owner can alter the database 'xxx'. Can somebody please help ASAP? Thank you in advance.
View 3 Replies View RelatedHi all,
How do I make SQL Server db table permissions take effect?
I just gave select permissions to a table but still not working.
Thanks.
Kevin.
What is the lowest level of permissions to see user created stored procedures? Example, it is possible to see "sp_" stored procedures but not yet possible to see "usp_" stored procedures.
View 2 Replies View RelatedGreetings.
I'm attempting to set up a database on SQL Server Express using PHP (PhpBB3 install) and ODBC on Windows XP (sp3). Whenever I run the software I get the following error:
======================================================================
A fatal and unrecoverable database error has occurred. This may be because the specified user does not have appropriate permissions to CREATE TABLES or INSERT data, etc. Further information may be given below. Please contact your hosting provider in the first instance or the support forums of phpBB for further assistance.
install_install.php [ 1181 ]
SQL : CREATE TABLE [phpbb_attachments] ( [attach_id] [int] IDENTITY (1, 1) NOT NULL , [post_msg_id] [int] DEFAULT (0) NOT NULL , [topic_id] [int] DEFAULT (0) NOT NULL , [in_message] [int] DEFAULT (0) NOT NULL , [poster_id] [int] DEFAULT (0) NOT NULL , [is_orphan] [int] DEFAULT (1) NOT NULL , [physical_filename] [varchar] (255) DEFAULT ('') NOT NULL , [real_filename] [varchar] (255) DEFAULT ('') NOT NULL , [download_count] [int] DEFAULT (0) NOT NULL , [attach_comment] [varchar] (4000) DEFAULT ('') NOT NULL , [extension] [varchar] (100) DEFAULT ('') NOT NULL , [mimetype] [varchar] (100) DEFAULT ('') NOT NULL , [filesize] [int] DEFAULT (0) NOT NULL , [filetime] [int] DEFAULT (0) NOT NULL , [thumbnail] [int] DEFAULT (0) NOT NULL ) ON [PRIMARY]
[Microsoft][SQL Native Client][SQL Server]CREATE TABLE permission denied in database 'master'.
======================================================================
If this were an Oracle database, I'd know what to do. Since this is the first time I've ever messed with MsSQL, I'm not sure exactly where to start.
Any and all clues greatly appreciated.
Ed.
We've just rolled out Reporting services at our organisation, and the users love it. However, it's giving me a headache because, as the only developer in the company and as I have VS.NET, I'm the only one who can author the reports.
Does anyone know of a third party provider that has written a report writing tool with a straight forward UI ( a bit like the access report writer for example) that I can deploy to some users and let them run riot? It's the kind of thing that I expect someone will have done as a pet project, if anyone knows of a freeware version that would be even better.
I'd be very grateful for any pointers.
Thanks
Hi all,
We are retriving tables from DB2 and loading into a SQL server. while retriving temporary tables are getting created in the linked server. we need to delete the data in those temporary tables in Linked server. I don't know how to write delete statement for the tables in linked server. any pointers would be appreciated.
Thanks in advance.
Shriram
1) SSRS export to Excel functionallity has an important limitation... is terribly slow when exporting huge amount of data to Excel.
2) Subreport are not supported to export in excel. This is some known issue and limitations of SSRS.
Hi there, i have sometimes trouble to write data to a table in a sql server expr. database.
i have a vb.net application that writes every 2 minutes data to a table. sometimes (no regulary phenomen) the error appears after some hours, sometimes after some days. then i cannot write data in the table. it seems that the database sleeps or is offline.
before i write the data i check if the connection is open and i can write data.
if i cannot write the data i try several times and often after the third try i can write the data.
i have checked everything (no power save's on or other power off modes)
i have also test it with SqlClient.SqlConnection.ClearAllPools()
and many other things to find the bug, but no success at the moment.
it seems that the database or the table is away ?? or sleeps for some seconds ?!? i have no idea.
could you help me ?
Greetings Andreas
Dear friends,
A simple question to you... witch of this dataflow destination is better for performance to write data in a SQL Server 2005:
1. SQL Server Destination?
2. OLEDB Destination?
3. Other?
Thanks!
hi Experts,
any one tell me that how to write code to take back up of sql server database?
hi,
I need to write a clr stored prodeure.i have to call that stored procedure from my prediction query.My Application is going to make use of that query to get the prediction output.
Is it possible to write clr stored procedure with out using adomd server.How?
For example:
In My Assembly i am having a function PredictPerformance(),Which is having my DMX Query.I need to execute that function from my analysis service by calling like this,
select aly. PredictPerformance() FROM [Model].
how to do this?
I am trying to backup two 40 GB database on server A and server B.
Server A is SAN attached and has 70GB free space for the backup.
Server B is NOT SAN attached and uses a local drive with 113GB free space.
Both backup's result in the same problem. The below is an extract from sql server log file regarding the errors.
Code Block12/18/2007 12:24:01,spid64,Unknown,BackupDiskFile::OpenMedia: Backup device 'H:MSSQL.1BackupfiveDWfiveDWfiveDW_backup_200712181200.bak' failed to open. Operating system error 2(error not found).,
12/18/2007 12:24:01,spid64,Unknown,Error: 18204<c/> Severity: 16<c/> State: 1.,
12/18/2007 12:23:54,Backup,Unknown,BACKUP failed to complete the command BACKUP DATABASE fiveDW. Check the backup application log for detailed messages.,
12/18/2007 12:23:54,Backup,Unknown,Error: 3041<c/> Severity: 16<c/> State: 1.,
12/18/2007 12:23:54,spid64,Unknown,BackupMedium::ReportIoError: write failure on backup device 'H:MSSQL.1BackupfiveDWfiveDWfiveDW_backup_200712181200.bak'. Operating system error 33(error not found).,
12/18/2007 12:23:54,spid64,Unknown,Error: 18210<c/> Severity: 16<c/> State: 1.,
Please note timings in log extract.
All help is appreciated
Thanks, Chris
sub = 1
DETAILED-VOUCHER
VOUCHER-A OCCURS 13 TIMES.
ACC-NUM PIC X(6).
ADB-V OCCURS 12 TIMES.
CNT-V PIC 9999 COMP-3.
AMT-V PIC S9(9)V99 COMP-3.
It is a initialization of the two dimensional array DETAILED-VOUCHER(Temporary Variable) which consists of the account number for that account number different group of people say as (teachers, state police etc) have different 12 kinds of amounts such as (DEATH-AMT, PAYEE-AMTetc ) for every account number. SUB (Temporary Variable) is used as subscript whose value will be incremented by 1 after initializing current position by zero in order to initialize all 12 positions in array.
LOP-ZERO-2.
MOVE ZEROS TO CNT-V (1 SUB).
MOVE ZEROS TO AMT-V (1 SUB).
ADD 1 TO SUB.
IF SUB NOT GREATER THAN 12
GO TO LOP-ZERO-2.
MOVE 2 TO SUB.
LOP-ZERO-3.
MOVE CNTS (1) TO CNTS (sub).
ADD 1 TO SUB.
IF SUB NOT > 13 GO TO LOP-ZERO-3.
MOVE '401.21' TO ACC-NO-V (1). ---------- This are the hotcode values
MOVE '410.01' TO ACC-NO-V (2).
MOVE '410.02' TO ACC-NO-V (3).
MOVE '410.03' TO ACC-NO-V (4).
MOVE '410.04' TO ACC-NO-V (5).
MOVE '410.06' TO ACC-NO-V (6).
MOVE '410.05' TO ACC-NO-V (7).
MOVE '411.01' TO ACC-NO-V (8).
MOVE '411.02' TO ACC-NO-V (9).
MOVE '331.01' TO ACC-NO-V (10).
MOVE '212.19' TO ACC-NO-V (11).
MOVE '212.22' TO ACC-NO-V (12).
MOVE ZEROS TO XYZ-S (1).
MOVE ZEROS TO MNO-B (1).
MOVE ALL '9' TO A-KEY
MOVE 01 TO D-X.
MOVE 1 TO SYS-Y
Please give suggest me how to write logic in the sql server. I want to how to write two dimensional array loop in the sql server.
Hello All,
I want to write Batch Program which will insert Data into Table every day based on some conditions.
can anyone please let me know how to write Batch Process in SQL server 2005??
Thanks.
Where can I find the information about dbcc setcpuweight? I checked books online and couldn't find it. I also went and searched Google with the same results. Any help is greatly appreciated.
View 2 Replies View RelatedQuestion for you. Due to some testing within our environment, I've restored a database a few times
today. Now, when I look at the databases that logins have access to, some have the correct
access to databases and others have no access anymore. This all has happened since I've
restored the database. What happened? It isn't even with the 1 database that I restored that
this is happening. When I look, most users don't have access to any database anymore... All the groups I have
set up and the permissions assigned within the database themselves are fine, just the
login doesn't have access to a database. Did I do something wrong? If so, please let me know
so I can correct it before another restore is necessary.
Thanks so much!
Toni Eibner
I am converting a multitude of Access databases from 2.0/95/97 to xp and at the same time moving to a client/server model using SQL Server.
This is the first time I have used SQL Server and I am having problems that seem to be related to permissions: I am unable to select, go to, update or delete a record via the application I have built. This may be a flaw in my development skills or a problem with permissions. I cannot find how to apply universal permissions to every column in every table (which is what i want at this point) and any changes that I do make are not reflected in Access.
Any ideas are gratefully received.
Hi all,My project modules in MS-Access rely heavily on DAO permissions. Now the access front end is being hooked up to a SQL Server 2005 back end, and I'd like to sync the permissions of linked table objects with the corresponding views when they are created/recreated.I'm vaguely aware there are a substantial number of differences between the the SQL Server and Jet security models. Initially, I'd like to create a lookup table to handle this. My problem is that I don't seem to be able to find much info on groups and object permissions in the SQL Server security model - perhaps I'm asking the wrong questions.:confused: Can anyone provide a link to a decent site for SQL Server novices?Ta
View 1 Replies View RelatedIs the security granularity in SQL Server 2005 good enough that I can allow certain users to have permissions to use Profiler ONLY on their database with out granting them sysadmin privilege? I know that it uses the master database which makes it complex. Thanks in advance.
View 3 Replies View RelatedI had created three users for my centeralized database server.
usernames are
1.sa
2.production
3.praveen
I had given the permissions as follows
for production i given the permissions for each database
dddatawriter,datareader, db_executor,public
for praveen i had given full permissions
for sa I want full permissions so i had given each and every thing
my aim is as follows. i want permissions according to this one.
for production he is not able to change the coloumn name,he is not able to backup database or restore database, and also he is not able to change password of any logins
For this one i got it correctly . but while coming to praveen login
He is able to do anything regarding database . but i don't want to give permissions to chnage passwords of his login and at the same time any login . can you give any idea regarding this permissions.
For sa i want to full permssions he is able to change passwords of any login .
please kindly help me in this