I'm trying to export excel data to a SQL Server database as:
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
'Excel 12.0;Database=D:DATA_SOURCEData2.xlsx', 'SELECT * FROM [Sheet1$');
I get errors:
Error Message: The OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" reported an error. Access denied.
Is there any reason for this error message? Thanks.
Hi Cindy,
After hours (days?) researching this, your name keeps popping up, you must be the GOTO person for VFP. So:
We have a server that runs a VFP application and stores .dbf free tables in a directory shared as F:apps ele.
I am working on an XPPro box running SQL Server Express 2005 using Management Studio Express.
I am logged on as a user with administrator rights for the domain
We would like to be able to query this data and move it to our SQL tables as needed.
Here is what I have:
EXEC sp_addlinkedserver @server = 'tele',
@srvproduct = 'VFP',
@provider = 'VFPOLEDB',
@datasrc = 'F:apps ele',
@provstr = 'VFPOLEDB.1'
GO
SELECT * FROM tele...PROSPECT_DIVU
Here is what I get:
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "VFPOLEDB" for linked server "tele" reported an error. Access denied.
Msg 7301, Level 16, State 2, Line 1
Cannot obtain the required interface ("IID_IDBCreateCommand") from OLE DB provider "VFPOLEDB" for linked server "tele".
I have tried:
exec sp_addlinkedsrvlogin
@rmtsrvname = 'tele',
@useself = false,
@locallogin = NULL,
@rmtuser = 'admin',
@rmtpassword = NULL
go
Same result.
I have also tried:
EXEC sp_addlinkedserver
'tele2',
'Jet 4.0',
'Microsoft.Jet.OLEDB.4.0',
'F:apps ele',
NULL,
'dBase IV'
GO
When I run:
select * from tele2...prospect_divu
I get:
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2" returned message "The Microsoft Jet database engine could not find the object 'prospect_divu'. Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "tele2". The provider supports the interface, but returns a failure code when it is used.
What would you suggest?
Hello there,
I recently started having trouble with my local SQL Server 8.0 database server. When I try to start it with Enterprise Manager I get the following error:
An error 5 - (Access is denied) occured while performing this service operation on the MSSQLServer service.
Nothing showed up in the SQL Server error logs. If I try to connect to it using the SQL Server Management Studio that came with SQL Server 2005 I get the following (slightly more informative) message:
Cannot connect to (local) ... (provider: Named Pipes Provider, error 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)
I'm not sure which log to look at in the MSSQL folders: MSSQL.1, MSSQL.2 or MSSQL.3.
Furthermore, if I manually start the MSSQLSERVER service, then I can connect just fine with the SQL Server 2005 Management Studio but still get the weird error message with SQL Server 8.0 Enterprise Manager.
Any ideas?
Thanks
Hallo
i'm trying to connect a VFP DBC as a linked server on MSSQL2000sp3a, using following parameters:
Product name: VFP
Data source: \networkpath odbc
Provider: VFPOLEDB.1
No security context
I'm trying the same operation both from a W2000sp4 server (+ MDAC 2.8sp1 ?) and a WXPPsp2, against two identical copies of the DBC that resides on two different path (one on the final path and one on a test path).
From WXPPsp2 everything runs ok, from W2000 i'm always getting this error:
Error 7399: OLE/DB Provider 'VFPOLEDB' IUnknown::QueryINterface returned 0x80070005: Access Denied
(already reported in this thread, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1832362&SiteID=1 but it didn't helped me)
The error happens independently from the user the query runs under (basicly AD account, both domain admin and normal user).
MSSQL runs under a domain account which have full permissions (for test purpose) on the directories where DBC reside.
I did no further modifications on the WXP machine in order to have the linked server running, simply it ran smoothly from the beginning.
Clearly the difference rely on the different OS... but what else?
i ran component checker to determine the MDAC version but some components version numbers slightly differs from the expected ones (eg. resulting version is 2.0.1064 versus 2.0.1022 expected in MDAC 2.8) so i suppose to have MDAC2.8 sp1 on the server.
thanks in advance
Using BULK Insert with a format file I am receiving the following message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'STREAMS' reported an error. The provider did not give any information about the error.
The statement has been terminated.
I am running SQL Server 7.0 w/ SP1 applied. The same data file and format files work fine if I use bcp.
The data file contains fixed length records.
Any ideas what the problem is?
My link server was working just fine until friday evening.
It stopped worked over the week end.
with and error Error 7399: OLE DB provider 'MSDAORA' reported an error. OLE DB error .
---my oracle 10g client is working just fine
--TNS names looks fine
---i recreated the link but i am still getting the same error.
I need your help because a lot of jobs are using that link on Monday it is going to be crazzzy.
In a previous post in Installation and Setup I was having problems just getting an ASP.NET 2.0 app to run on my web server. Now I'm having some different weird security issues.
I'm getting this message when just trying to open a database and put its contents into a gridview.
Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'sqlEmployees' because of security settings.
I think this may have to do with our web server and our SQL server being separate machines. That always gives us issues. But I have impersonation=true in my web.config along with windows authentication and I have SQL Server configured with Windows and SQL authentication so things should be right, I'm thinking.
Any ideas??
Hi all,
I am currently working on a stored procedure in SQL 2000 where I use OPENROWSET function to read data from an Excel file into a temporary table.
It works fine when I logged in with username 'sa' and psswrd 'sa' but when I log in with another user name and password I get the following error:
"Ad hoc access to OLE DB provider 'Microsoft.Jet.OLEDB.40' has been denied.
You must access this provider through a linked server."
I am using VB 6.0 as front end. Is there anyway i can overcome this error?
Please help.
Dhiraj
When running the following statement in SQL 2005, I get the error message "Access is denied":
exec master.dbo.xp_cmdshell 'TYPE \SERVER-BSHAREFILE.TXT'
The following are true about the network:
The SQL Server is installed on SERVER-A.
SERVER-A and SERVER-B are Windows 2003 servers on the same Windows 2003 domain.
The SQL Server and SQL Server Agent services are running under the domain account SQLSERVICE.
SQLSERVICE is a member of the Domain Admins group.
The Domain Admins group is part of the local Administrators group on SERVER-B.
The SQLSERVICE account has also explicitly been given Full Control to the folder referenced by \SERVER-BSHARE
xp_cmdshell use has been enabled on the SQL Server.
If I run the following command in SQL:
exec master.dbo.xp_cmdshell 'whoami'the following is returned: DOMAINSQLSERVICE
If I change the command to access the c: drive instead of a network drive, it executes successfully.
Can anyone shed some light on why I still cannot access any of the files in this folder using xp_cmdshell?
Tim
Hi -
I have an File System Task that copies a file from one directory ot another. When I hard code the target directory (c:dirfile.txt) it works fine. When I change it to a virtual directory (\serverdirfile.txt) I get a security error:
[File System Task] Error: An error occurred with the following error message: "Access to the path '\gracehbtest oS2TMM_Live_Title_000002.xml' is denied.".
Where do I change the security settings?
Thanks - Grace
HI ,
This is a problem I encountered when I had to detach a database file (type .mdf):
1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse.
2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful
3) However when I tried reattaching the database file, I got this error:
CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "CProgram FilesMSSQL ServerMSSQLData<databasename>.mdf'
Q) The database file and log file (ldf) exist in the correct directory so I don't know what happened. Can any one help?
Thanks much
Tonante
Hello everyone.
I am trying to install Project Server, and i'm having issues with sharepoint, and connecting to SQL:
dataserver is running sbs2003 sql2003 and analsys services.
server2 is running server2003 is to be the application server for project.
ProjectDb is the database that i have setup in sql.
username is the account that can control everything as administrer.
in Sharepoint is asks for the database server: <<dataserver>>
SQL Server database name: <<ProjectDb>>
I'm using windoes authentication and then i click ok, and get the error message.
I've also see the error message can not find the SQL Server, and access denied. Under ODBC i have installed the sql server information under System DSN.
Any help would be great.
Thanks
Everett Buel
A couple months ago I created a DTS package to use the Bulk Insert task for importing a series of large files from a different server. It worked great until last week. Now, when I try to use the Bulk Insert task in a DTS package, I get the following message, "Could not bulk insert because file "blah.txt" could not be opened. Operating System Error 5 (Access Is denied.) I have checked permissions on the file, the file is valid and the path is correct.
What can I look at to understand what is wrong? How can I fix this?
I am posting this message after reading all the previous posts withthe above subject.I have a SQL2K named instance running on a Windows 2K machine underLocal system Account and it uses SQL Server authentication. ThisServer is on a domain by itself. Let us call this M1.I am connecting to this server from an XP machine usinng EnterpriseManager. Let us call this machine M2.Since the client and server are on differentt domains when I useServer Manager on M2 to start/stop my M1's SQL Server, SQL ServerAgent etc, I am getting this error message -"Access Denied (Error 5)When starting SQL Server Service"?What user detailed are passed from M2 to M1 that I am getting thiserror? What is the best way to use server manager on M2 to control M1?Also how to know the status of a SQL server Agent from a cleint EM.
View 1 Replies View Related
I'm trying to solve this error from so many days and not able to get any solution till now, pls help on this.
My reports are working fine after being deployed on Windows 2003 Server with SQL Standard Edition. But on 2 sites, I'm using SQL Express Edition with Advanced Services on Win XP Pro machine.
This is a C# Applicaiton, using reportviewer control and getting reports from reportserver. I'm using following code before the report is refreshed to set credentials.
These machines are not on domain and using common workgroup. I have created a account with admin rights on these machines, which is being passed to reportviewer control.
MyRepPrevForm.reportViewer.ServerReport.ReportServerCredentials.
NetworkCredentials = new NetworkCredential("MyUser", "MyPass", WorkGroupName);
I have tried everything on this, including the giving additional rights to Aspnet account, adding it as login etc. etc. but nothing seems to work.
Can somebody pls help on this.
Hi ,
I am getting access denied error when tried to import or export data from another machine. ( right click on database in management studio , select tasks , select import or export) i was getting that error in the second screen of the wizard which asks to select the source system to copy from. Previously in this process i got error while sql initialization which comes after selecting source ,destination system and database tables selcetion. i have searched the net for the sollutoin and got a sollution mentioning to install the sql service pack 1. while installing i kept my server running , in the middle of installation what happend is a message box is diaplayed saying something and showed three options cancel,continue and try again. i mistakenly clicked on continue without stopping the server. after successfull installation of service pack i once again tried to import data from other system. the above mentioned error is giving in the second screen of the wizard at the place where to select the source system. i tried to system restore but updates of service pack does not reflected. hoping that some one may solve my problem.
this is the message
General access denied error
------------------------------
Program Location:
at Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass.get_DBProviderInfos()
at Microsoft.SqlServer.Dts.DtsWizard.DTSWizard.GetDtsDbProviderInfos(WizardInputs wizardInputs)
at Microsoft.SqlServer.Dts.DtsWizard.DataSourceCombo.PopulateProviders(Boolean fSources, WizardInputs wizardInputs)
at Microsoft.SqlServer.Dts.DtsWizard.Step1.OnInitializePage(EventArgs e)
at Microsoft.SqlServer.Management.UI.WizardPage.RaiseEnterPage()
at Microsoft.SqlServer.Management.UI.WizardForm.NextPage(WizardPage nextPage)
at Microsoft.SqlServer.Management.UI.WizardForm.Next_Click(Object sender, EventArgs e)
I have created a stored procedure that dumps the database from
server 'A' and copies the dump file to server 'B'. I get 'ACCESS'
DENIED' error in the following portion when it shells out to DOS:
SELECT @CmdStr = 'COPY ' + RTrim(@PrimaryCopyDev) + RTrim(@DBDevice) + '.dat ' + RTrim(@SecondaryCopyDev) + RTrim(@DBDevice) + '.dat'
EXEC@result = Master..xp_cmdshell @CmdStr
Can anyone tell me what is wrong? Thanks in advance.
I am pretty new to MS SQL Server ....
I have installed SQL Server Enterprise Manager Version 8.0. I am getting the following error while try to create a new DTS Package.
"DTS designer Error .... Access Denied"
getting the DTS packge design window but there is no TASK icon visible
either in the tool bar or menu.....
Enterprise Manager Version 8.0
OS : Windows XP pro with SP1
Yesterday afternoon I lost access to my local MSDE 2000 sp3(a?)instance. Usinig NT or SQL authentication I get an 'access denied'error when I try to connect. This happened suddenly with no changesto the server on my part. I've tinkered with the Client NetworkUtility settings, from Multiprotocol only, every combination of Multiprotocol, TCP/IP, and named pipes. I've tried connecting with mynetwork machine name, using (local), and using my IP address (both127.0.0.1 and my network IP). I've tried connecting from QueryAnalyzer on other computers. Of course I've rebooted as well, all tono avail.I know that there were network changes being made, but my domain login(which I normally use to connec to my SQL Server as a sysadmin) isstill in the local administrators group on my machine and I haven'tnoticed any problems accessing anything else.Any ideas?
View 1 Replies View RelatedI have created a package that works just fine from my desktop. I am now testing it by deploying it to the server. The task was imported into the "File System" store. I connected to the SQL Server, from my desktop, with SSMS. I right clicked the package and selected "Execute" If I just validate the task, it validates without errors. When I go to run the task I get a "Access to the path is denied" error at the start of the first file system task. I am sure it is a permission issue. Based on the info from another thread in the forum:
"Security to network shares is dependent on the user who is running the package. If you are running it yourself, make sure you have permissions to the share. If you are running it from SQL Agent, you might need to use a proxy account (search for SQL Agent Proxy in Books Online) to access it."
I have some questions:
1. When I select "execute" what account is SQL Server using for permissions for accessing network folders? Is it mine, SQL Server Agent, something else? If it is my account, why would I get an "Access to the path is denied" error?
2. I don't understand how to use a proxy account, or even if I need one. I assume that when I set the task for scheduling I'll need one. I read the BOL pages, but I'm still confused as to what I need to set up.
Any info would be greatly appreciated.
Thanks,
Lee
I am getting an error when trying to access SSIS packages stored in the MSDB section. File access works, but I get an Access Denied error with the MSDB access. I've tried through the SQL Server Management Studio on the server and on a remote workstation. I've logged on with multiple users; to no avail. Has anyone encountered and solved this problem yet? I've noticed several posts that appear to be similar, but there are no resolutions that work for me.
Any suggestions will be appreciated.
Thanks,
Stephan
Hi,
I'm trying to connect to my local database running on SqlServerExpress. I'm able to connect to it from SQL Server Studio. I'm also able to create a data connection to the database from VS.NET 2005 using server explorer. However, when I try to pull some data from my code, I get the "SQL Server does not exist or access denied." error.
Here's my code:
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" DataSourceID="SqlDatasource1" /><asp:SqlDataSource ID="SqlDatasource1" runat="server" SelectCommand="select * from tStates" ProviderName="System.Data.OleDb" ConnectionString="Provider=SQLOLEDB;Server=.SQLSERVEREXPRESS;database=TestaDB;uid=sa;pwd=SAPassword" />
I'd appreciate some help on this.
Hi guys,
I just installed WebMatrix and MSDE (downloaded from www.asp.net), and I have set MSDE to use SQL authentication. I have granted user ASPNET read/write previlege and added it to the MSDE user's table. When I tried the following code, it gives me this error: "SQL Server does not exist or access denied."
<%@ Page Language="C#" Debug="true" %>
<%@ import Namespace="System.Data" %>
<%@ import Namespace="System.Data.SqlClient" %>
<script runat="server">
void Page_Load(object sender, EventArgs e) {
// TODO: Update the ConnectionString and CommandText values for your application
string ConnectionString = "server=(local)/BERKELEY;database=emonopoly;Trusted_Connection=yes";
string CommandText = "select * from test";
SqlConnection myConnection = new SqlConnection(ConnectionString);
SqlCommand myCommand = new SqlCommand(CommandText, myConnection);
myConnection.Open();
DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
DataGrid1.DataBind();
}
</script>
<html>
<head>
</head>
<body style="FONT-FAMILY: arial">
<h2>Simple Data Report
</h2>
<hr size="1" />
<form runat="server">
<asp:datagrid id="DataGrid1" runat="server" CellSpacing="1" GridLines="None" CellPadding="3" BackColor="White" ForeColor="Black" EnableViewState="False">
<HeaderStyle font-bold="True" forecolor="white" backcolor="#4A3C8C"></HeaderStyle>
<ItemStyle backcolor="#DEDFDE"></ItemStyle>
</asp:datagrid>
</form>
</body>
</html>
I turned on the debug option, and the exact output is this:
Server Error in '/' Application.
--------------------------------------------------------------------------------
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.
Source Error:
Line 13: SqlCommand myCommand = new SqlCommand(CommandText, myConnection);
Line 14:
Line 15: myConnection.Open();
Line 16:
Line 17: DataGrid1.DataSource = myCommand.ExecuteReader(CommandBehavior.CloseConnection);
Source File: D:PersonalProjectsMS.NeteMonopolysourcedatareport.aspx Line: 15
Stack Trace:
[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +311
System.Data.SqlClient.SqlConnection.Open() +383
ASP.datareport_aspx.Page_Load(Object sender, EventArgs e) in D:PersonalProjectsMS.NeteMonopolysourcedatareport.aspx:15
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The strange thing is I'm able to connect to the MSDE database from the DATA window on the right hand side of the WebMatrix design window. Will somebody give me a hand?
And yes, I did make sure the MSDE is running.
Thanks alot
Chris
I have re-installed Visual Studio and SQL Server and now i am getting this error for all applications i try to runError:"
SQL Server does not exist or access denied.
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: SQL Server does not exist or access denied.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: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +384
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) +44
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) +36
ResNet2.top_animals.BindGrid() +64
ResNet2.top_animals.Page_Load(Object sender, EventArgs e) +525
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
"any suggestions?
I'm trying to create to set up connection between my web application on the server and
the database on another box and getting "SQL Server does not exist or access denied" error.
Both the web server and the database machine are Windows 2003 Server, there's no firewall
enabled, there's mixed authentication enabled on the sql server. The machines are not on the
same domain so I'm using SQL Server authentication from web.config. Here's my connection string:
<add key="ConnectionString" value="Server=sqlboxip;User id=sqlaccountname;Pwd=sqlpass;Initial catalog=dbname">
I've also got <identity impersonate="true"> set in web.config.
Had it the connection working at some stage but then with more tweaking and app reinstall
back square one... Please help!</identity></add>
Hi,
The install of SQL Express with advanced services on my WinXP Pro PC seemed to go fine but now I look at it and see that the actual SQL server hasn't installed. The log files says:
Product: Microsoft SQL Server 2005
Log File: ...SQLSetup0003_HKM1_SQL.log
Last Action: Install Finalise
Error String: Failed to set registry settings for server network libraries. The action is SetShilohRoot. The error is 5 (Acces is denied)
Also getting the same error for product: SQL Server Database Services.
Any help would be greatly appreciated.
I guess I messed up somehow, but I am not sure how to fix this.
On Vista, with SQL Server 2005 Developer Edition, I created a 6GB database and loaded it up with data. I then decided that I wanted to burn a copy of the files, so I detached (no problem.) But when I wanted to copy the physical MDF and LOG file to another folder. Vista said I did not have access to the folder, but if I hit continue, no problem--it would correct the situation. I did. I copied the files (no problem), but now when I go to reattach to the MDF (that is still in the Data folder), I get a "CREATE FILE encountered operating system 5 (Access is denied)" error. I checked permissions and SQL Server has full rights. I am the only user on the system (Admin), and the files do not appear to have anything weird set (read only, advanced permissions, etc.)
What did I do wrong? And how do I fix this? Oh the joys of advanced Vista security features Even the admin is locked out now.
Thank you for your help!
Michael
After installing SQL Server express to my WinXP machine, when I attempt to restore a database from a 2000 backup, I get the following error:
System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTEST.MDF'. (Microsoft.SqlServer.Express.Smo)
Any ideas?
Hi, my name is Beatriz and I'm another victim of the 0x80070005 from
Hell. I'm running WBEMTEST from a PC to connect to another one with WXP
SP2 and even:
1. The firewall is down.
2. Applied the commands:
netsh firewall set service RemoteAdmin enable
netsh firewall add portopening protocol=tcp port=135 name=DCOM_TCP135
3. Did the workaround suggested in:
http://support.microsoft.com/kb/909444
4. Ran the workaround in: http://support.microsoft.com/kb/884573
5. Added the account I use to access by Wbemtest with to the Default
Lauch Permissions with Full Control.
6. Checked up the registry
:HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlLsaforceguest
were set to 0.
I keep not being able to connect, and receving 0x80070005, what I'm
missing?!?!?!?
Hello All,I have a webservice uses a vb.net component that accesses thrid party dll to connect to a sqlserver dbase, username,dbase name ,server and password are passed to the third party dll for login purpose.This works fine in development evironment when pda client calls webservice, A soap error is thrown to the client "sqlserver does not exist or access denied" when the client calls the deployed webservice. I have tried the following 1. Added ASPNet user to the database 2.Added domian user to the database both has public and dbowner rightsCan any one help??[:'(]Thanks Regards
View 1 Replies View RelatedI copied my .mdf database from a file and pasted it into the visual studio project App_Data folder.I can see the tables and the columns etc when creating my TableAdapter, and create my sql query etc, but then when I hit the finish button, I get this error "an Unexpected Error has OccuredError Message: Access Denied". Anyone know why I can't create my TableAdapter?
View 7 Replies View RelatedI have set up an MSDE SQL Server in my Win XP Pro PC and am able to connect to it on the host PC, and over my LAN. However, when I try to connect to it over the Internet my connection is refused with the following message:SQL server does not exist or access denied. ConnectionOpen (Connect())Some background:I have router/NAT firewall and have opened port 1433 (I have even tried a DMZ to the SQL Server machine). The Router is definitely going to the SQL Server PC! I am fairly certain that the connection string is correct.Any help would be most gratefully received.
View 7 Replies View RelatedHello!
When I start my .aspx with ASP.NET Web Matrix Server, it work, but when i try to start it with IIS I get error message.
TIA,
Misha