473,395 Members | 1,680 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

writing permission on SQL server

17
Hi,
I connect the SQL server in my application using this code :
ConnectionStringSettings settings =
ConfigurationManager.ConnectionStrings["StockDB"];
con = new SqlConnection(settings.ConnectionString);
but I have no writing permission the database is for read only what should I do in order to add writing permission?
thanks
Eran
Nov 2 '08 #1
7 1760
kenobewan
4,871 Expert 4TB
Connect through an admin account or upgrade your log in or add user account with appropriate permission or create a SP with the right permissions or impersonate the dbo account??? Bit strange, having read only access to a DB...
Nov 3 '08 #2
eranby
17
mmm.. I guess there are many solutions , but I'm new to SQL server and the default permission is read only , I have searched a lot for an answer and didn't find any ,may you guide me how to implement one of those solutions ??

Thanks
Eran
Nov 3 '08 #3
Frinavale
9,735 Expert Mod 8TB
I've moved the question to the MS SQL Server forum.

-Frinny
Nov 3 '08 #4
eranby
17
I need to connect to the sever and write to it from the c# application can the help me with that??
Nov 3 '08 #5
ck9663
2,878 Expert 2GB
Call your system administrator to give you the necessary rights.


-- CK
Nov 4 '08 #6
eranby
17
this application is on my on pc, there are no administrators involved
Nov 4 '08 #7
ck9663
2,878 Expert 2GB
Where did your database come from and why don't you have the necessary rights on your own db? Login using the sa account, then.


-- CK
Nov 5 '08 #8

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: letkok | last post by:
Help! When I run the VB program in test mode while looking at the code, it functions correctly and creates the desired file. When I compile it on the server and try to have it run from the...
12
by: Russ | last post by:
Hello. My new dev machine is running XP Pro. In the past all equipment has only used Windows 2000. I have had a lot of problems getting my projects up and running on the new machine. The current...
2
by: Taishi | last post by:
New user of SQL Everything is on the same machine My error is close to the bottom After reading it today, I can see there is a problem with 2 dbases 'PUBS' and 'Master' There are also some...
0
by: Gazelle | last post by:
I have a dilemma, that I am hopping I can find some help with. He is the back story so everyone sort of understands what it is that I am trying to accomplish. My problem: I have multiple...
6
by: MattC | last post by:
I have some code that correctly writes to the eventlog on my local machine. I have installed the application on the Live server and all is not well, no event log entries. My development box...
7
by: Mike L. | last post by:
Hi, I got this 'EXECUTE permission denied on object <mySproc>' error message everytime I try executing my SQL server Sproc. What's this and how to fix this err? many thnaks in advance, mike
2
by: MattB | last post by:
I'm writing some code to log errors in a web app (vb/asp.net). I found a straightforward-looking example here: http://www.c-sharpcorner.com/Code/2002/May/CustomErrorHandlingASPNEt.asp But mine...
2
by: =?Utf-8?B?REo=?= | last post by:
I've created a new EventLog for mail services in my web application. Each time a mail is sent, it is recorded in the eventlog for later review. This works fine when I am on my development machine...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.