I want to connect sqlce 2.0 to sql server 2005. From "Connectivity Tools for SQL Server Compact, SQL Server Mobile, SQL Server 2000, and SQL Server 2005", I know I should install sql server 2005 without the replication components. I do it, then i find i can not create publication. Without replication, how can i synchronize between sqlce 2.0 and sql server2005?
Anyone can help me?
Thirst for your answer.
I'm attempting to use RDA to synchronize a pocket pc emulator with SQL Server 2005 database by following tutorial http://msdn2.microsoft.com/en-us/library/aa454892.aspx, which uses AdvWorksMobile database that comes with SQL Server 2005.
When get to testing of "To test application features " ( step 4 of the merge replication setup lab ), I am receiving SQLCe Exception errors.
ORIGINALLY, I was able to deploy an application and view the local database on the emulator, but once I clicked "InitSinc" button, I received an error.
"Failure to connect to SQL Server with provided connection information. SQL Server does not" exist, access is denied because the SQL user is not a valid user on the SQL Server, or the password is incorrect.
Found this error listed in Server Agent Errors log http://technet.microsoft.com/en-us/library/ms172357.aspx, but it wasn't very helpful since it doesn't provide any suggestions on fixing the problems.
I am brand new to SQL CE Server , mobile programming and .NET framework in general so please bare with me
All the connections / security settings, etc that were set up were taken from a tutorial so I am not sure what SQLCeServer is complaining about. Reading up on the error on the web didn't help, it all pointed to making sure that the snapshot folder had correct permissions set up. I verified that MACHINENAMEUISR_MACHINENAME guest user had Read rights to the database so I don't think that piece is the problem. Otherwise ,Merge publication has been setup in Microsoft SQL Server Management Studio by following the tutorial.
I am trying to run this sync on my home pc so there should be no issues with any user permissions
I have IIS installed
I did NOT have SQL Server Agent running in management studio at this time
I am trying to run this tutorial on an XP machine, which is my regular home PC so I dont think there are any special networking settings to consider
I am able to hit http://localhost/AdvWorksMobile/sqlcesa30.dll from my pc OK, but when I try to hit it from a cradled emulator ( after replacing "localhost" with "MACHINE_NAME" ), Internet Explorer on the emulator gives me a "Cannot Connect With Current Settings" error message. This part wasn't part of tutorial but decided so not sure if I am supposed to be able to hit it from my emulator..so I am not sure if the fact that I can't hit it is related to the problem.
AFTER STARTING SQL SERVER AGENTin Microsoft SQL Server Management Studio, I killed the application, and after relaunching it, it hits "The Specified table does not exist [Vendor]" error. This time it doesn't even launch first - that is I dont even get to pressing "InitSinc" button. Debugger is showing that this error is hit on the following line in AdvWorksMobile.AddWorksDataSetTableAdapters
int returnValue = this.Adapter.Fill(dataTable);
I am not sure why the errors changed on me after starting SQL Server Agent.
What can I do to fix this connection problem?
Thank you so much for your help!
Irina
I'm having a problem connecting with a Java application but I CAN connect using my .Net application - the user name and password are the same for both (using the same database on SQL Server Express 2005).
The error I get is: "com.microsoft.sqlserver.jdbc.SQLServerException: Cannot open database "CORNERS" requested by the login. The login failed." An interesing note - I get the same message if the database is not running.
SQL Server Express 2005 is installed in mixed mode.
Here is my connection string in the .Net appplication: <add key="connectString" value="Server=(local);UID=sa;PWD=myPasswd;Database=CORNERS" />.
These are my values in my Java app web.xml -
<init-param>
<param-name>DBDriver</param-name>
<param-value>com.microsoft.sqlserver.jdbc.SQLServerDriver</param-value>
</init-param>
<init-param>
<param-name>DBURL</param-name> <param-value>jdbc:sqlserver://localhostsqlexpress:1055;databaseName=CORNERS</param-value>
</init-param>
<init-param>
<param-name>DBUser</param-name>
<param-value>sa</param-value>
</init-param>
<init-param>
<param-name>DBPwd</param-name>
<param-value>myPasswd</param-value>
</init-param>.
And yes, the port is 1055 - I checked to find it.
I am using Microsoft SQL Server 2005 JDBC Driver 1.0 (sqljdbc_1.0.809.102).
Does anyone have any idea what is wrong so that the login fails in the Java application but works in the .Net application?
I presently run on my server SQL SERVER CE 2.0 and want to install, in addition on SQL Server 2.0, SQL Server Mobile 2005.
Is there a procedure to have both installed and running on a computer?
Thanks!
Marco
Hi,
Could some one guide me hot copy tables/Data from SQL 2005 to Sql 2005 Compact Edition?
Thanks
Dear All,
I have downloaded Microsoft Synchronization Services for ADO.NET CTP from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=75FEF59F-1B5E-49BC-A21A-9EF4F34DE6FC&displaylang=en
This download package contains the SQL Server Compact Edition 3.5 and I have installed the same. Before that I was having SqlCE 3.1 and able to work with that fine from C# application on Desktop.
After installing the new one I could see V3.1 and V3.5 folders at: C:Program FilesMicrosoft SQL Server Compact Edition. But when I tried to create a new data connection from Visual Studio 2005, it directly making use of V3.1.
Does anybody know how to make use of this newer version in my C# application with in Visual Studio 2005 and also enabling the same in SQL Server Management Studio?
It€™s an urgent requirement for me; please do spend couple of minutes in providing the solution for this.
Thanks in advance
I am currently upgrading our ppc app (written in .net 2003) to .net 2005 and from sqlce 2.0 to 3.0. The new application runs out memory(storage) when handling lots of data transactions (both in case of using sqlcedatareader, and dataset ). There is no memory leak issue here, sqlce 3.0 simply uses a lot more (3 times more) memory than sqlce 2.0.
Our applicaton runs fine using sqlce 2.0 and .net 2003, but fail due to memory shortage
with the upgrades(which has the same code). Anyone can shed some lights on this issue?
hi,
I have some SQL CE database .sdf file on my handheld, and I was trying to connect to that file via SQL Server 2005 Management Studio, and it does not work. I am wondering if there is any good tool that I can use on desktop to connect to sqlce .sdf database file on my handheld?
Thanks.
Hi,
I have VS Pro 2005 and SQL Server Express 2005 installed on an XP Pro machine. When using VS 2005, in the 'Server Explorer' window I can see and attach to two SQL Server databases that I have set-up. But if I attempt to access the same databases from withn the 'Solution Explorer' window I get the following dialog box message,
"
Required Component Missing (Dialog box heading)
Connections to SQL Server Files (*.mdf) require SQL Server Express to function properly. Please verify the installation of the component or download from the URL: http://go.microsoft.com/fwlink/?LinkId=49251
"
I have uninstalled and then reinstalled both VS 2005 and SQL Server Express twice but it has helped.
I don't understand why I'm getting this error because all of the server configuration tools and connection utilities seem to work fine but VS say's that SQL Server Express is not installed.
Thanks,
CLN
P.S.
I had another application that required MSDE 2000A to be installed. When I removed the other application I also removed MSDE 2000A and that's when the problem began.
Hi,all BI experts here,
Thank you very much for your kind attention.
I am having a problem with connecting to SQL Server 2005 database from Office Business Scorecard Manager 2005 (the connection string i am using is: provider=SQLOLEDB;Data source=server_name; Initial catalog=database_name). But the connection failed. Would please any experts here shed me any light on what is the problem and how to fix it then? As there is no any forum for Office Business Scrorecard manager 2005. Therefore I post my thread here as it is related to the connection to SQL Server 2005 database engine, thought here is the best place for this question.
Thank you very in advance for your kind advices and help. And I am looking forward to hearing from you soon.
With best regards,
Yours sincerely,
I've used Sql Server 2000 and Visual Studio 2003 for a few years. I've started a new position and they have access to Sql Server 2005 Standard and Visual Basic 2005 Express which I'd like to use for a new project. So I installed Sql Server 2005 and then VB 2005 Express on my workstation. I didn't choose the Sql Server option for VB Express because I already had Sql Server 2005 Standard installed with a simple database created. I created a simple vb project that justs connects to the database but I get the following error.
Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0000, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I looked at permissions in the database and it looks ok. I'm the db owner and I'm using Windows Auth. My connection string is
"Data Source=MySystem;initial catalog=AdventureWorks;integrated security=true;"
I thought I'd look at the starter kit to get some ideas about what the problem is, but when I started the movie starter kit project, it was upset that I didn't have Sql Server 2005 EXPRESS installed. Yea, but I do have Sql Server 2005 Standard installed.
Any help will be greatly appreciated. Thanks.
I've installed, with default settings, VS 2005 and Server 2005 Express and cannot get VS2005 to connect. This is the error:
Unable to open the physical file "..path...mdf". Operating system error 32: "32(The process cannot access the file because it is being used by another process."
I shutdown Server 2005 but that didn't change anything. Any ideas?
Thanks.
I have installed MS Visual Web Developer 2005 Express Edition on my Notebook (WinXP Pro SP2). And it's working fine. Then I tried installed SQL Server 2005 Express Edition SP1. There is no error during installation and it seems to be working as I can see the SQL Server (MSSQLServer) service is running. As SQL server configulation manager., the protocal shared memory , named Pipes and TCP/IP are enabled.
But when I want to add connection using VWD 2005 by pointing to datasource (MS SQL Server database file and selecing file from .mdf file from SQL sample database file. Then test connection, I got a error that
"An error has occurred while establishing a conneciton to the server. when connecting to SQL server 2005, this failure may be casued the the fact that under the default settings SQL server does not allow remote connections. (provider: SQL Interfaces, error: 26- Error locating server/instance specified)
Can you please advise what the missing part of my configulation ?
Thanks
Hi there,
I install microsoft server 2005 and I use the microsoft server management studio express tool to get connection and database tables set up.
To connect to server:
Connection server: localhostSQLEXPRESS
Authentication: windows authentication
Then I click on connect button
I create the tables in YCH1-1SQLEXPRESSDatabasesSystem DatabasesmasterTables
where YCH1-1 is my machine name
The table I have created is called staff I put in the code below in the web.config file but it does not work when I try to insert data into staff table
<appSettings><add key="ConnectionString" value="Data Source=(local);Initial Catalog=Master; 
 Integrated Security=true;"/>
</appSettings>
Error in statement: connection.open()
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Can anybody help me ? Thank you in advance.
I have installed SQL Server 2005 Beta 2 on my PC. When I try to make aconnection to it from the DTS environment, I get following error:=============================================Could not get server list. (DTS Import/Export Wizard)=============================================[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or accessdenied. (Microsoft OLE DB Provider for SQL Server)----------------------------------------Making a connection from within SQL Server Management Studio works fine.If I try to connect from within a .NET program using SQLConnection, itfails on the conn.Open() call. But SQL Server Management Studio worksfine.Has anyone run into this? Could someone please help?Rob
View 1 Replies View RelatedI cannot seem to connect to SQL server on my local machine.
where would i post this question?
Hi, I've installed the evaluation version of sql server 2005 and sp2 on my local machine running vista 64 .. .I can see the mssqlserver service running but I don't see any mssqlserver available in management studio.. maybe i have to do something in the configuration manager? i wish these tools were more intuitive, feel like I'm guessing and testing
View 1 Replies View Related
all,
I have the standard edition of SQL Server 2005 installed on a WIN XP Pro machine. I setup file and print sharing with my laptop. What do I need to be able to connect to SQL Server on my WIN XP Pro machine from my laptop. I hope to do most of my developing on my laptop. Do I need the developers edition of SQL server 2005 installed on my laptop?
I have developed a website that connected to sql2000 db
Now that I have upgraded to SQLserver2005, I always get the follwing message after launching the website:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/iisHelp/common/500-100.asp, line 11 Dim objASPError, blnErrorWritten, strServername, strServerIP, strRemoteIP Dim strMethod, lngPos, datNow, strQueryString, strURL
--------------------------------------------------------------------------^
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié
/FMCQ_Web/Include/Modules/modADO.asp, line 18
I have tried different things (security access, DSN, etc...)but seems that nothing is working,
Can someone out there suggest a move to get this going..
Hi All,
One of our database server has upgraded from SQL Server 2000 to 2005 version some days ago, but I found the application which could run before cannot work fine now. I have followed some intructions got from other guys, such as replace the old driver with a new version, but it still did not work. Now I have two questions
1. What is the driver implementation class name? I found there were several answers. (I don't use XA connections)
2. What is the data source helper class name?
I suspect that the above questions are the causes. However, please give me some other hints if any.
Thank you very much!
Hi
I need to know how to connect my DB which is in SQL 2005 with the IIS server, hopefuly this will be in much detials bcuz its my first time working on this staff
Thanx
in my application, i can seem to use every page, but ONE. when i access this page, i get the error:
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
I have taken the time to answer the questions listed here:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=975683&SiteID=1
[1] Client side:
What is the connection string in you app? <Setting Name="ConnectionString" Public="False">Server=(local);User ID=asdf;Password=asdf;Database=cwTRU;</Setting>
If client fails to connect, what is the client error messages?
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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Is the client remote or local to the SQL server machine? Local
Can you ping your server? YES
In cmd.exe console, type €œping -a <server_name>€?.
Can you telnet to your SQL Server? NO, server is local, Connecting To briansomethingdifferent...Could not open connection to the host,n port 23: Connect failed
In cmd.exe console, type €œtelnet <server name> port, where port can be 135, 445 or sql_server_tcp_port. If your cmd.exe console turns into a complete black screen with a cursor flushing on top left corner, you are connected. Type ctrl+€™[€˜ to bring up telnet prompt and type €œquit€? <enter>.
What is your client database provider? ADO.NET2.0 other (please specify] Or/And, what is your client application? Visual Studio
Is your client computer in the same domain as the Server computer? Same domain
What protocol the client enabled? TCPIP | Named Pipes.
Do you have aliases configured that match the server name portion of your connection string? If so, please check if it is correct. You can use cliconfg.exe (SS 2000) or SQL Server Configuration Manager (SS 2005) to configure the alias. no aliases
Do you select force encryption on server and/or client? no
[2] Server side:
What is the MS SQL version? SQL Sever 2005
What is the SKU of MS SQL? not sure, enterprise i believe
What is the SQL Server Protocol enabled? Shared Memory | TCPIP | Named Pipes. Use SQL Server Configuration Manager to configure it and check ERRORLOG or event log to confirm.
Does the server start successfully? YES
If SQL Server is a named instance, is the SQL browser enabled? YES
What is the account that the SQL Server is running under?Local System
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider? not applicable
Do you make firewall exception for SQL Browser UDP port 1434? In SQL2000, you still need to make firewall exception for UDP port 1434 in order to support named instance. not applicable
[3] Platform:
What is the OS version? Windows XPSP2.
Do you have third party antivirus, anti-spareware software installed? no.
[4] Misc:
If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question.
Tips:
1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG
Last but not least:
There is a wealth of information already available to help you answer your questions.
(1) SQL Server 2005 Books Online: http://msdn2.microsoft.com
(2) Microsoft Support Knowledge Base: http://support.microsoft.com
(3) SQL Protocol Team Blog: http://blogs.msdn.com/sql_protocols
(4) MSN Search: http://search.msn.com/ or use your favorite search engine.
Hello,
I have a problem with connecting to SQL Server 2005. I have a small network at home with a WLAN router connected to Internet. My notebook computer and desktop computer are connected to router. My SQL Server 2005 is installed on notebook computer and Microsoft Server Management Studio is installed on desktop computer. I wanted to add login so I could connect to it from desktop pc and a problem came up. When I tryed to add account (from desktop pc) to local group on notebook pc I couldn't do that becouse there wasn't offered desktop pc as a location. Also, when I try to make connection string in visual studio, i can see sql server but i can not choose database. Is this becouse of router or is it posible to do that only in a real server(domain)?
Hi, I'm new to all of the SQL server stuff. I just started using Visual Web Developer 2008 to create a website for my company. However, I encountered a problem a while ago that i haven't been able to solve. First, i could not edit the security settings for my website (an error came up that i tried to fix before, but nothing worked). I don't remember what the error was. However, I've uninstalled and re-installed both Web Developer and all of the SQL programs, and an error comes up: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server
I'm not sure what this means, but i can't seem to solve it. I've tried to do some things suggested by the ASP.NET configuration utility and by other forums, but even those things have been blocked, coming up with the same error message: 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server)
that's the whole of the error message.
What can i do to solve this, I just want to develop the website with Web Developer
http://server5.pictiger.com/img/990335/computers-and-electronic-gadgets/connection.jpg
I don't know how to connect sql server 2005 with sqljdbc.jar which is used in Netbeans IDE 5.5
how can I solve the above problem?
thx a lot
jdbc:sqlserver://localhost:1433;databaseName=mydatabase
is this url correct?
Does anyone have any instructions on how to go about uprading a .sdf file
from sqlce 2.0 to sqlce 3.0?
I found this on an msdn website
(link: http://www.microsoft.com/sql/editions/sqlmobile/upgrading.mspx) but
as you can see its very lacking on detail. (I included the link and content
referring to upgrading the database files so you won't have to go to the link
to see the part referring to upgrading the database.) I tried to run the upgrade.exe on my device but it doesn't explain how you're supposed to point it to the .sdf that you are trying to update. Here is the content on the above web page.
Upgrading Database Files
You can upgrade a database created with an earlier version of SQL Server CE
2.0 to a database created with SQL Server Mobile by using the SQL Server
Mobile Database Upgrade tool (upgrade.exe). The Database Upgrade tool runs on
a smart device.
When you run the SQL Server Mobile Database Upgrade tool, the new SQL Server
Mobile database is created on the smart device. The new database, with the
file name extension .sdf, contains all the data that was in the source
database. You need to reinitialize the upgraded database to continue using it
for replication.
Note: If you are using replication or remote data access (RDA) as a
connectivity solution before upgrading to SQL Server Mobile, you must
synchronize the source SQL Server CE database (subscription database) with
the SQL Server database (Publisher). The reason for synchronizing before
upgrading to SQL Server Mobile is to ensure that any changes that exist in
the tables on the SQL Server CE database are updated on the SQL Server
database, because after the upgrade you must resubscribe or repull using the
new database.
Can I connect from a SQL Server 2005 database to a SQL Server 2000 database, without establishing a linked server connection.
I need to fire a SELECT query on a SQL Server 2000 database, but don't want to add it as a linked server. Is there any way I can do this or its not possible??
HI,
I have a standard 3 tier architecture which uses asp 2.0 and sql 2005. The SQL 2005 machine is remote and when trying connect to the db server from my logon page I get a page cannot be found once i click submit on the logon button.
I have carried out the following checks:
1 ) MAde sure that SQL Server has enabled the TCP/IP and network pipes from configuration manger.
2) I have checked that the remote connections is enabled from surface area configuration.
3) I have ensured that the network service account has privilages on the web server.
4) I am using forms authentication.
5) I have used the following connection string:
connectionString="Network Library=DBMSSOCN;Database=My_DB;data source=ServerName,1433;password=pasword;User ID=Myuser;Integrated Security=false;"
6) I have tested his connection string from a windows forms application and it s working fine.
Can someone please help me out here as I cant work out at is going wrong????
Thanks in advance
Garry
I am having a strange problem. I have an application that to connects to SQL Database in SQL Server 2005.
When I run the application with Visual Studio everything works fine but when I deploy the application on my web server and then to access the site .
I get an error : Login failed for user ''. The user is not associated with a trusted SQL Server connection.
For some reason the application is not passing the user name . I have checked the IIS and authentication is set to Integrated Windows Authentication .
My connection string is correct as well
<add name="xxxxx" connectionString="Data Source=xxxxxx;Initial Catalog=xxxx;Integrated Security=SSPI" providerName="System.Data.SqlClient"/>
I will appreciate any kind of assistance in this matter. Thanks
Hi everyone, I'm new here!I've begun work on a project for a new client, and we have a dedicated server set up with Fasthosts. To save cost, I've decided to install SQL Server 2005 on the same machine that the site will be running on.Well, I've installed SQL Server 2005, and can connect to it from within the server itself, but I cannot connect from outside (it's set on port 1433, and it's not being blocked). I've looked at firewalls, security policies etc.. but still I'm getting the same error:-Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456) - or indeed any user I set up.I have created another user within SS2005, but above I'm just showing 'sa' for example (although the same error occurs when using the default 'sa' login).PLEASE can someone help me, or suggest things to try. Fasthosts themselves aren't helping much, because essentially they can't support this type of setup (they have their own dedicated SQL Servers, which we opted not to use).Many thanks in advanceAndy
View 11 Replies View RelatedHello,I am trying to connect to a SQL SERVER 2005 database. The database file is in App_Data folder under Inetpub/[AppRoot]Here's the Connection String:"Data Source=SERVER2/YUKON;AttachDbFilename=C:/Inetpub/MyNotes/App_Data/MyNotesDB.mdf;User ID=sa;Password=****"Every time I try to connect I get a this error on my page: "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."Here's the stack trace:[SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +684979 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +207 System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +890 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +601 System.Data.SqlClient.SqlInternalConnectionTds..ctor(SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +159 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +346 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +445 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +66 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +304 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 MyNotes.Membership.MembershipManager.CreateMember(MemberProfile objMemberProfile) in c:InetpubMyNotesApp_CodeMyNotes.Membership.cs:21 _Default.Page_Load(Object sender, EventArgs e) in c:InetpubMyNotesDefault.aspx.cs:23 System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +36 System.Web.UI.Control.OnLoad(EventArgs e) +102 System.Web.UI.Control.LoadRecursive() +47 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1064Thanks in advance,Arnie
View 1 Replies View RelatedHi
I can't connect to sql server 2005 from my asp.net web page. I seem to be able to connect to it when i run the application from within visual studio but i can't connect to it when i run the application from IIS.I am new to sql server 2005 express so please bear with me.The error message i get is: Cannot open database "Vets" requested by the login. The login failed.Login failed for user 'OSCAR2K4ASPNET'.I don't know where this user OSCAR2K4ASPNET came from but i looked in sql server 2005 and there he is. In the left hand pane I went to Security and then logins and found oscar2k4asp.net there. I went to the properties for this user and went to User Mappings. There was no tick next to my Vets database so I added one and ran the application from IIS. I also added the user to every single role in the vets database (including dbowner). I also went into the vets database itself and found the oscar/aspnet user and made sure he was added to every role.
I ran the application again. This time i got a lots of different errors. If the page was trying to run a select procedure I got the error user does not have select permission. If the page was running an SP i got the error or user does not execute permission
I have never had this problem before so I don't understand.Where did this user come from? Was he created automatically when i configured my database for membership and roles? How do i set up this user so he can access the databsae from IIS.
The only way I could get the application to run from IIS was to go to Security - Logins for sql server and add the oscar2k4asp.net user to the sysadmin role.
I find this very strange. Naturally i don't want to leave oscar2k4 in sysadmin.
Please help :) I can't upload my website until i fix this
Thanks, andrea
all,
I have the standard edition of SQL Server 2005 installed on a WIN XP Pro machine. I setup file and print sharing with my laptop. What do I need to be able to connect to SQL Server on my WIN XP Pro machine from my laptop. I hope to do most of my developing on my laptop. Do I need the developers edition of SQL server 2005 installed on my laptop?