We have build and ASP.Net web application and also running another application that runs as a windows service.
We are having a problem with SQL 2005 express in that :the service and the webpages are able to access the resource individually,but when both are trying to access the resource, that is creating a problem and give us SQL access errors.
The application works perfectly under SQL 2000
Anyone have any suggestions?
We have a windows forms app (VB.NET) that uses SQL Server 2005 Express in user instance mode. We have installed the app on hundreds of Win2K and WinXP PCs without any problems, but have run into an issue with one customer's site. They are running Win2K SP4 and we have installed the application on a couple of PCs at the customer's site to determine if it is environmental. The error occurs as the program is starting up the user instance of the database:
Error information:
System.InvalidOperationsException: An error occurred creating the form. See Exception.InnerException for details.
The error is: User does not have permission to perform this action, ---> System.Data.SqlClient.SqlException: User does not have permission to perform this action.
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.TrhowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbCOnnectionOptions option, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(dbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbCOnnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbCOnnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
This error occurs at the first attempt to write to the database during the program startup. Any ideas?
Shawn
This may be an idiotic question:
I am attempting to use Visual Web Developer Express with a connection to a SQL Express db from a non-admin account on my XP Pro SP2 machine.
I can do everything in the app under an admin login, but can't seem to configure the db to allow the non-admin account access to the db. I've tried tweaking WMI, using Network Service, Local Service, and Local System with NT AUTHORITY, individual logins, and group permissions, but I'm stuck.
Any thoughts?
I just spent the better par of 3 days creating a prototype in ASP.Net 2.0 and SQL Server Express only to discover that nobody from outside can see it...
ERROR with impersonation=true
User does not have permission to perform this action.
ERROR with impersonation=false
Unable to open the physical file "c:inetpubwwwroot------.mdf". Operating system error 5: "5(Access is denied.)".An attempt to attach an auto-named database for file c:inetpubwwwroot-----.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
What makes this so difficult?
What am I missing?
I'm trying to build a web application using SQL2005 Express and Visual Studio Express. It all works OK on the local machine, but gives an error "Login failed for user xxxxASPNET" when used remotely. I can't find where I can set login permissions for SQLServer 2005 Expresss - can anyone help, please?
Thanks
John
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'm trying to learn some VB programming with the VB 2005 Express Absolute Beginner Series video tutorials (which I think is great) and have come across a problem that I can't solve.
When I follow the instructions in Lesson 9 (Databinding Data to User Interface Controls) my application will display the data from the database correctly and I can edit it (and as long as the debugger is running the data remains changed). However, the changes won't propagate back to the database. I don't get any error messages but after I edit the data, save (with the save button on the BindingNavigator toolbar), and end debugging the data in my database remains unchanged. When I use a MessageBox to show how many rows where edited/updated in the
Me.myTableTableAdapter.Update(Me.myDatabaseDataSet.myTable)
I get the correct number back. I'm sure the problem is not due to coding errors since I've also tried running the accompanying Lesson 9 project file that can be downloaded from MSDN and the problem persists.
I'm using Windows XP SP2, SQL Server 2005 Express Edition and VB 2005 Express Edition. I've tried installing SQL Server 2005 Express with a number of different settings, including default settings, but it doesn't make any difference.
Would greatly appreciate any feedback on this as I'm keen to resolve this problem so I can get on with the next tutorial lesson.
Thanks,
Ieyasu
Hi
I have a vm machine running SQL Express. So as to centralise my data, on the host machine I have a folder with all my data. This folder is shared. In the vm machine I have set up mapped to this folder, so it is visible within in. I can add/remove from the folder in explorer so the permissions look okay up to there.
However, when I go into SQL Express and attempt to restore from a backup into a DB, I cannot see the folder in the folder list presented. When I try and force the connection through the mapped drive letter or unc name, the server fails with a you do not have permissions.
From my reading it looks like I have got a network service account set up but, when I look at the logins in SQL Express there doesn't appear to be such an account.
Could someone either
a) point me in the right direction if the netowrk service account is not the way to go
b) tell me how to set up a netowrk service account with the correct privileges to enable me to read /write this mapped folder.
Thanks
Simon
After installing SQL Server Express I can now connect using my Windows authentication but am unable to create a database because all BUILTINUsers only have public permissions. I don't have the sa password and there are no other users or user groups set up which I could use to upgrade my permissions. So I can't do much of anything with SQL Server.
For background, I'm setting this up on a personal laptop running Windows Vista. I'm one of only two users on the machine and I have an Administrator user account.
Any help is appreciated.
posted to the forums a few weeks ago, followed the suggestion but the problem has not been squared, the link for my original post is at the bottom of this message.
have tried most of the suggestions in the forums, again see the link for details on steps i have tried, kept poking around and came up with a few more possibilities for the problem,
the error message is the one that says sql server express remote connnections are not enabled by default during the install of sql express,
backed up a little and it seems i can not even connect to the local machine, i ran the sqlcmd -s -e sqlexpress and the login timesouts and says that sql express refused the connection, have shared memory protocal and tcp/ip running also tried it with named pipes,
so that left me wonderin if maybe permission for sql express need to be adjusted, brought up SQL server Studio Mangement Express console and went to the only express instance on the local machine, brought up properties for sqlexpress and went to the permission section and noticed the following:
for the BuiltInadministrator and builtInUser account the only permission that is checked off is the "Conect SQL" which has only the Grant checkbox checked, also the grantor is sa, btw what does the checkbox With Grant do?? this was the same for the both accounts,
for the public account the only permission that is enabled is the View any database,
are there other permission which need to be granted or "with granted", also i assume i should not be using the sa account or should i?
other things going on include include Visual Studio 2005, i am able to get to the database thru Server Explorer, and can bring up the tables and see them, sometimes thos their is a red x on the mdf, but when i click it brings them up.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=217258&SiteID=1
HiIm trying to connect Visual Basic Express 2005 to a remote SQL Server Express 2005. I cant find how i can do that in VB.net Express.In Web developer there are no problem to connect to a remote SQL server but i cant find it in VB.net Express. The XP with the SQL server that i want to connect to is on the local network. Greatful for help!
View 1 Replies View RelatedThis problem only occurs after deployment, not when debugging. In the table I am having a problem with I have an ID field designated as the primary key with the identity increment set to 1 and the identity seed set to 1. There is no data in the table when deployed. I can add records to the datagridview control but when I try updating the dataset I get this error indicating that the ID field already has a value of 1 present. If I close the application and re-start it, the exception no longer occurrs when I update the dataset. I am including the code to update the tables incase something is wrong there. Any suggestions?
Private Sub UpdateMemberTable()
Me.Validate()
Me.TblMembersBindingSource.EndEdit()
Me.TblMembersTableAdapter.Update(Me.ChurchFamilyDataSet.tblMembers)
Me.TblMemberDependentsBindingSource.EndEdit()
Me.TblMemberDependentsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberDependents)
Me.TblMemberContributionsBindingSource.EndEdit()
Me.TblMemberContributionsTableAdapter.Update(Me.ChurchFamilyDataSet.tblMemberContributions)
End Sub
Hi Guys,
I created a Product database table using Visual Basic 2005 Express and SQL Server 2005 Express. I have just added a new column [Picture] to the database table, which of course, should store an image or picture of a product. I am writing to kindly ask you guys for help .
i) How do I include image files into this column [Picture]?
ii) How do I get this image to display on Visual Basic 2005 Express form, so that when a product is selected the product image is displayed accordingly?
Your help much appreciated. Thanks.
Paul
When I installed VS 2005, it installed the default version of SQL Server 2005 Express that ships with Visual Studio 2005 installer media.
How can apply SQL Server 2005 Express SP1 to update this existing instance?
Currently, if I run this query:
SELECT @@version
I get the following:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
After applying SP1, I should get 9.00.2047.00.
Should I just go to this link and download & install the SQL Server 2005 Express Edition SP1:
http://msdn.microsoft.com/vstudio/express/sql/download/
Thank you,
Bashman
This is what I have done.
1. Installed VB.NET IDE 2008 and SQL Server Compact 2005. IDE requires upgrade of database to 3.0 version which I allowed it to do. After the database was upgraded, I did an amount of coding work in the IDE and then tried to go back to do more database work in SQL. However the database then could not be opened in SQL Server Compact 2005. An error said that because it had been upgraded, it could not be read. It was requiring me to run 'upgrade.exe'. I had no idea what this meant and could find no upgrade available online.
2. Removed VB.NET IDE 2008 and installed 2005 instead. However, the file extension on the SQL Server Compact database is .sdf, but the IDE is requiring a .mdf extension. I have tried everything I can think of to get it to save or to have the desired extension, but I cannot.
Questions:
1. Do SQL Express 2005 and VB Studio Express 2008 work together?
2. If so, how?
It seems as though application each requires a different version of the database. If the database is usable in one, it is not usable in another.
Thanks for the help.
Julie
I have a 2005 Express DB I wish to attach to using the 2005 Mgt Studio Client (Not the express version, but the full blown 2005 Mgt Studio Client from the SQL 2005 Standard Edition Install disk). Can this be done, or can I only use the 2005 Mgt Studio Express Edition Client?
Thanks in advance.
M. Scott Blalock
View 2 Replies View Related
I am trying to debug a sp, I did it like a month ago and now i am getting msg:"
T-SQL execution ended without debugging. You may not have sufficient permissions to debug"
The server is a remote server
ANY help PLS!!!
I am trying to debug a sp, I did it a month ago and now i am getting msg:"
T-SQL execution ended without debugging. You may not have sufficient permissions to debug"
The server is a remote server
ANY help PLS!!!
The dba says nothing has changed regarding my user log in or domains. I am a sysadmin user (he tells me) , I have looked up info but really dont understand any of the stuff, (i am a super dummy! and just started this job 5mo ago, and learned from reading a book, so i dont have any great understanding about domains or anything. Pls help
Hi guys
Am i able to deny the SA account access to a specific database?
thanks in advance for your help.
TheGing
In SQL/2000 EM I can go to a user Database, expand the Users, double click a user and click Permissions to see everything a user has permisson to in the database. How can I get the same information in Management Studio in SQL/2005? Is there an overview of this process in BOL 2005?
Thanks in advance!!!
DeWayne
I am just migrating to SQL Server 2005 and I am having difficulty
figuring out how to do some tasks that were easy under SQL Server 2000.
Specifically, I am not sure about object permissions.
(This is
what I did for SQL Server 2000) For database access by my web
application, I added a SQL login for the IIS_WPG group. I then added a
database user (name ASPNET) associated with this database login and
give it only datareader and datawriter privileges. I would then
'double-click' the user, which would bring up the list of securable
objects. I would then click the 'execute' permission for all of the
user-created stored procedures. [done]
For SQL Server 2005, I am
not quite sure what to do. It seems to me (based on what I see after
importing the tables), that a schema should be used, but I do not see
any explicit permissions in the schema. On the other hand, if I select
each stored procedure and look at its properties, I can see that the
ASPNET user has execute permission.
It seems inconceivable that
the only way to configure permissions is to modify each SP by hand.
This would take more than 10 times as long as the SQL Server 2000
method of assigning permissions.
So, my question is this:
How
can permissions be assigned 'wholesale'? (i.e., some method akin to the
SQL Server 2000 method that does not require setting permissions on
each individual object individually.)
Of course, if you care to suggest a better way to do this, I'd love to hear it!
Thank you.
Hi. I created user: "Reporter"
This User is set as my anonomoys login user in IIS 6.0. I gave him permissions on both the database server & the Report server, however I keep getting an error. "The permissions granted to user 'SRVRReporter' are insufficient for performing this operation. (rsAccessDenied).
I inherited the task of syncing up these new reports & I'm trying to follow what the last guy did (not exactly though, that's why I created the new user)
I gave the new user login rights on both servers as well as access to the SQL 2005 database. I have the identity impersonate="true"
Can anyone out there tell me what permission I need to grant to get my reports to run?
If i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
View 1 Replies View RelatedHi,
I have a table in my database where I want the Insert/Modify permissions to only administrator or (User X). Remaining users can just read the data. How do I set this in sqlserver 2005 database?
I can right click Table->properties->Permissions and add specific permissions to admin. But how would i deny permisssions to all others? I cannot add each login to deny permissions.
Thanks,
All,
I have been asked to grant a Windows group Full access to all tables under our Sandbox Schema. This will allow these users to do anything to the tables under this Schema.
I created the Windows Group (Sandbox Users), created the login in SQL, created the user in the database that is tied to the Windows group, then ran GRANT CONTROL ON SCHEMA::[Sandbox] TO [Sandbox Users].
I have verified that the users are in the Windows group, but they state that they still can not delete tables under the Sandbox Schema.
Anyone have any ideas?
Thanks,
Justin
Hi,
When i try to acces the rdl file from the aspx page i get the following error
"The permissions granted to user 'MACHINENAMEASPNET' are insufficient for performing this operation. (rsAccessDenied) "
Where do i need to give persmissions for this report to show up correctly?
Any pointers would be appreciated.
Thanks
Rohan Wali
Hi all,Just wondering if SQL 2005 express edition can be connected remotely. I've set up SQL 2005 Express on a separate machine and am having trouble connecting to it from VWD when creating the websites. Currently I've set up ASP.NET 2.0 Framework on the remote machine with IIS6 using Windows Server 2003 Web Edition. And I am directly editing the website remotely on the server machine from my PC. Could someone please help me in setting up a remote connection from VWD to the SQL Server?I've enabled TCP/IP setting in the SQL Configuration Manager but still getting errors. Could this be an issue with Express Edition? Because if it is I also have a copy of SQL Server 2005 to install. Any direction to resolve in this issue would be greatly appreciated.PS. I'm new to this so pls bear with me. Thanks.
View 1 Replies View RelatedI use Visual Web Developer Express 2005 with SQL Server 2005 Express. With this combination I was able to create a new database.I can add tables, views etc.But no triggers....do you guys have an idea how I can add a new trigger?Please help!
View 1 Replies View RelatedThis is a question about the movie collection starter So here it is:
I am running Vista RC1 (Build 5600) and vb express 2005
I downloaded and install SQL Server Express 2005 Edition SP2 - Since SQL Server Express 2005 Edition SP1 does not work with Vista
But when I try to run the collection app or if I try to download and install the Amazon version I get the following error message:
There was a problem loading data: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be cause 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)
I need any advice you can give me to solve this problem, how to change the default settings, because I do not know where to start.
Thanks
Ive created a DAL called Artist.xsd. Ive used stored procedures to access the data. The wizard created a stored procedure called 'dbo.ArtistSelectCommand' Ive granted the ASPNET account execute permissions on this stored procedure When I run the application and try to execute the stored proc, I get this error
EXECUTE permission denied on object 'ArtistSelectCommand', database 'EBSNet', owner 'dbo'.
as far as im aware ive givne the ASPNET account the correct permissions
EXEC sp_grantlogin [MachineNameASPNET]
EXEC sp_grantdbaccess [MachineNameASPNET], [ASPNET]
** Ive also done this by selecting the stored proc in sql server 2005 and setting permissions by right clicking and selecting properties.
Is there anything else I need to do ?
I have finally gotten a setup to work, but I suspect there are improvements I should make to the permissions. Here's the setup:
I am accessing two databases, (aspnetdb and my own database called custom) on a local SQL 2005 server.
In SQL Server Management Studio (SMS) I created logins at the level of the SQL instance for two users ( "NT AUTHORITYNETWORK SERVICE" and "viewer"). Then I select each user, and set the properties to access the Server Roles section. There I found each was given the public server role. Now here's where I set the permission to sysadmin. This setting allows my application to work, but I'm sure there are less permissive approaches I should take. However, I just can't seem to find a simple and direct explanation of the procedure to set more appropriate permissions. The "NT AUTHORITYNETWORK SERVICE" accesses aspnetdb in order to create users and membership settings. The "viewer" login accesses the database called custom, and it reads and alters this database. The application (which is name viewer) performs these operations using a connection string like this:
Data Source=STORE;Initial Catalog=custom;Persist Security Info=True; User ID=viewer; password=xxxxx;
What is the recommended way to set the minimal permissions for these logins on these databases?
I have a DataSet (Data Component in Beta 1) and I want to add Fill and
Get methods by using a Stored Procedure that was created by VS 2005 (aspnet_Membership_GetAllUsers). I probably need to use Enterprise Manager to do so but I am not sure what permissions I need to set and how to set them.