Help!
I'm writing some VB.net 2005 windows applications which connect to various tables within SQL Server 2005.
If my programs are running from C drive, I have no problems connecting to my database.
but if i run my exe file from a network drive, then the SQL server doesnt recognise the user's pc, and wont allow my program to access any data.
Can anyone help me with this problem?
Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
Hi everyone,
I€™m quite new to SQL Server so maybe this is an easy question but I haven€™t found the answer after 3+ hours of Googling and experimenting.
I have a simple set up €“ two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home network and both belong to the same Workgroup. There€™s no Domain involved. HELEN is running SQL Server Express while DELORES is the €śclient€?, running SQL Server Management Studio Express. I am using €śWindows Authentication€? and Named Pipes to allow DELORES to work with the SQL Server Express instance on HELEN.
I have a general understanding of €śWindows Authentication€? and I was hoping someone could fill in the gaps. I realize €śWindows Authentication€? uses the underlying Windows User Accounts on the server to validate incoming connections.
I€™m sometimes having a problem in connecting SQL Server Management Studio Express (running on DELORES) to the SQL Server Express instance (running on HELEN). This problem may be due to a lack of understanding of Windows User Accounts.
I€™ve found that if I use the exact *same* username *and* passwords on both machines, SQL Server Management Studio Express has no problem connecting to HELEN€™s SQL Server Express instance. If I change the username and/or password on only one of the machines, the connection fails. Also, if I keep the usernames the same on both machines but I delete the passwords, the connection fails again.
I realize I can set up a user account on HELEN. Do I then have to set up the same user account (with the same non-blank password) on Delores? So far, this is the method that€™s been successful. Is it possible for me to tell SQL Server Management Studio Express to use a particular account (username/password) when connecting to HELEN via Named Pipes? If so, how is that specified?
I admit to my confusion. Any help would be greatly appreciated.
Robin
Hi everyone,
I€™m quite new to SQL Server so maybe this is an easy question but I haven€™t found the answer after 3+ hours of Googling and experimenting.
I have a simple set up €“ two computers named HELEN and DELORES, both running Win XP Pro, SP2. These machines are connected via a home network and both belong to the same Workgroup. There€™s no Domain involved. HELEN is running SQL Server Express while DELORES is the €śclient€?, running SQL Server Management Studio Express. I am using €śWindows Authentication€? and Named Pipes to allow DELORES to work with the SQL Server Express instance on HELEN.
I have a general understanding of €śWindows Authentication€? and I was hoping someone could fill in the gaps. I realize €śWindows Authentication€? uses the underlying Windows User Accounts on the server to validate incoming connections.
I€™m sometimes having a problem in connecting SQL Server Management Studio Express (running on DELORES) to the SQL Server Express instance (running on HELEN). This problem may be due to a lack of understanding of Windows User Accounts.
I€™ve found that if I use the exact *same* username *and* passwords on both machines, SQL Server Management Studio Express has no problem connecting to HELEN€™s SQL Server Express instance. If I change the username and/or password on only one of the machines, however, the connection fails. Also, if I keep the usernames the same on both machines but I delete the passwords, the connection fails again.
I realize I can set up a user account on HELEN. Do I then have to set up the same user account (with the same non-blank password) on Delores? So far, this is the method that€™s been successful. Is it possible for me to tell SQL Server Management Studio Express to use a particular account (username/password) when connecting to HELEN via Named Pipes? If so, how is that specified?
I admit to my confusion. Any help would be greatly appreciated.
Robin
Hi,
I have 2 SQL 2K Servers set up on my home network. Both PC's are running Windows XP and as far as I can tell are configured identically, however I can connect to the Server A from PC B but not Server B from PC A (both work fine when I am on the same machine I try to connect to). Any ideas anyone, the error message I am getting is attached.
Hi!
I wrote an application which connects to a SQL Server / MSDE 2000 DB through ADO components. Now the application doesn't start if I don't have an active network connection; as far as I try to connect, the error I get is:
[DBNETLIB][ConnectionOpen (Connect()).].........
Everything is ok if I simply plug the network cable and let the PC connect to the TCP/IP network.
Hope someone can help me!
Thanks
Umberto
I have notebook, client server application and sql express sp2 on this notebook.
Also, I know domain user login/password,
but I don't know any local user name/password
and I don't know any sql server user name/password.
Domain user is not a local administrator on this notebook.
When notebook connected to the office LAN I am working good with my app-> my sql express as a domain/user.
I'd like to work at home too. I can logon to the system (XP SP2) using domain account when notebook has no network connection. (probably OS caches something)
Is it possible to work with sql express using domain login when no network connection?
PS. old version of this software used MSDE 2000 and it was possible(!).
Thank you.
I am able to connect to reportserver from within the network. However I am unable to connect to reportserver from outside of network.
I am using the syntax http://xxx.xxx.xxx.xxx:1433/reportserver where xxx.xxx.xxx.xxx denotes the ip adress and the 1433 denotes the port
Reportserver is on a windows 2003 small business server. I added exceptions to my firewalll and checked all permissions to the physical directories. I am sure it is a simple issue but cannot figure it out.
Any help would be appreciated.
Thanks.
Hi,
I am hoping you will be of assistance to me and provide a little advice on what exactly is possible using SQL Express / SQL Server 2005 with regards to remotely connecting to a server.
I am a final year undergraduate student studying computing sciences in the UK. As a final year project I am attempting to create a client-server database, where the client (a WM5 PDA) can connect to an SQL server hosted on a different machine (a PC). However, I must be able to connect to the server when the PDA is being used on any Wi-Fi connection.
Basically I want the PDA to be able to connect to a database kept on the PC at home when you're out and about using the PDA's wi-fi.
Is this possible? If so, could you explain in 'dummy' terminology how one would go about this?
As my university is part of the MS Academic Alliance I have access to VS 2005 and SQL Server 2005 for this project.
Many thanks for your time and I eagerly await your responses!
Simon
Hi
Please if any one can answer.I am developing .net vb app sqlexpress database.
In single user work ok.In multiuser from other computer on network I cannot get data.Any form without data workok fine . The error I am getting is as follows.
Application attempted to perform operation not allowed by the security policy.
request for permission of type
'System.data.sqlclientpermission,system.data,
version=2.0.0.0.,culture=Normal, publickeytoken=b77a5c561934e089'
Zaabdullah
Hi.
i got an error when i connect to sqlserver 2005 db with use of Sqlserver ManagementStudio.
A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - The specified network name is no longer available.) (.Net SqlClient Data Provider)(Microsoft Sql Error - 64)...
Is there a limitation in sql server 2005 express that it does not accept connections via the network? I am trying to develop a web application running the web server as a VM but I can't connect to the sql server on the host machine. Similarly, I can't create an ODBC connection on the VM, but I can on the host. I could install sql express on the VM, that is probably the next thing I'll try.
View 2 Replies View RelatedI'm trying to implement a SSAS Project in a Virtual Machine using a private network. When I try to deploy the solution the program gives me the following error:
I already have a Windows Authentication but still gives me that error.
Hi,
We are running a software which has a sql database and it runs a data cycle everyday in which it gets data from several other sql servers on our network.
Recently we have starting receiving the following errors during this run;
Network Error IOException: Connection Timed Out: Connect
It finishes most of the queries in the script, but on some (and not always the same tables) it gives the time out error. I am not quit sure where or how to research this problem.
Any ideas are welcome!
Thanks,
Michiel
Hello,
Ho do I allow multiple users to share a database?
Background
I have developed a Windows App in VS.NET 2005 which connects to a SQL 2005 Express database.
Now I want to install the app and database on the network and I am getting an error "File 'file_name' is on a network device not supported for database files"
What is the best way to get this working
Thanks in advance,
Phil
I recently created a program that connects to a Microsoft SQL database that was stored on my computer and it worked fine. As soon as I tried to connect to the same database via a network drive I got an error stating that "The file Y:Filename.mdf is on a network path that is not supported for database files.". I can't seem to get it to work, if anybody has any ideas what I'm doing wrong I would appreciate your help.
Don
I'm green on this networking stuff so any help is greatly appreciated.
I have setup my home computer as a server and assigned a static IP to it. I installed SQL Server 2005 Developer and allowed remote connections to it through the Surface Area Config tool, added port 1433 TCP and 1434 UDP to firewall's exception list, and started the SQL Server Browser service.
Now I can't seem to remote connect to this SQL Server from my office network. Is there something I'm doing wrong here?
Thanks!!
We just replaced an older Windows 2000 sp4 server with a new Window 2003 Standard Edition sp2 server to run our batch processing. We noticed that when the SQL command times out we now get the following error in the ADO command object error collection.
[DBNETLIB][ConnectionWrite (send()).] General network error. Check you network documentation.
Native Error: 11
SQL State: HY018
msado15.dll version 2.82.3959 is on this server.
On other servers running Windows 2003 Enterprise Edition sp1 the error on the ADO command object is normal with.
Timeout expired
Native Error: 0
SQL State: HYT00
msado15.dll version 2.82.1830 is on this server.
The SQL server they are talking to is on the other side of a firewall. It is SQL 2005 sp2 running on Windows 2000 sp4.
I have also tested this on a Windows 2003 sp2 server that doesn't have to cross a firewall and get the correct Timeout error. It also has the same version of msado15.dll as problem server.
The application is a collection of VB6 Components that are running in COM+ applications. I have isolated the test application to our one SQL interface component and have build a test vbs that can reproduce this on demand. The VB6 Components were not modified in any way for this change and have been working fine for many years prior to this.
All other aspects of our batch processing works as expected. Transactions are working fine. As long as the SQL doesn't timeout everything is normal. DTCPing was used to ensure both servers have correct ports open to allow DTC traffic. Checked the SynAttackProtect setting on SQL and this is not an issue since other clients have no problems.
One point I would like to add is that this new server was initially setup with a temporary server name and then was changed to use the name of the original server on move day. Don't know if this has any impact or not.
set up asp .net user account on sql server 2005Question:
I've read the instructions in this article: http://www.netomatix.com/Development/aspnetuserpermissions.aspxBut do not know how to do this:You can grant 'Network Service' or 'ASPNET' user accounts permissions to connect to database.Please provide example on how to do this, thanks!
When attempting SQL Replication I am getting an error that the user I setup for connecting to the Distribution database was unable to connect. I have setup a domain administrator user on our Domain (Active Directory) with the name of SDP. In order to test the SDP login I attempted to connect as DOMAINSDP, and it failed. If I login to Windows (2000) as SDP I can connect to the Server using Windows Authentication without any problem.
Why can I not connect using SQL Server Authentication as DOMAINSDP when I am logged into Windows as kblum? Is there some sort of setting that I need to establish to allow this?
TIA
I've scoured Google searching for an answer that seems like it should beeasy but apparently isn't...when I open SSMS to connect to a SQL 2005database and choose Windows authentication, it greys out the User Namebox...problem is, the server I need to connect to is in another domain...howon earth are you supposed to specify a different Windows user name toconnect with other than the one currently logged into the machine?-Ben--Posted via a free Usenet account from http://www.teranews.com
View 1 Replies View RelatedJust spoke w/ our network admin and he mentioned that we use SPI, so being brand new to ASP, i did some googling and found this string:
the username and password is the account i have for the database, which is windows authentication, so i made sure the domain was in there. i am unsure of what i am doing wrong.
set conn = server.createobject("adodb.connection")
Conn.open "Data Source=INTRANETSERV;Initial Catalog=facultyabsences;Integrated Security=SSPI;User ID=domainusername;Password=mypassword;"
conn.open connection
this is the error i receive:
Microsoft OLE DB Service Components error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.
/intranets/absentee/db3.asp, line 3
any help is appreciated.
WE have an appl testing the SQL security feature, at some point in time
they drop the BUILTINAdministrators group from the login,
changed the security mode to "Windows NT only", but no users have system admin
server role, after the SQL server was restarted, no one can connect to the server. No one has authority to change the security mode back to "mixed"
(all standard logons will not work)
Any comment ?
The way I can think of to fix the problem:
detach all user databases
run rebuildm.exe
reattach all user databases
recreate the required logins
Any other suggestions/solutions, Thanks
Anthony
I'm trying to connect to a database using my virtual machine, where I´m logged in as another user than the one that's granted acccess to the database. Can I enter the windows username and password used to connect to my SQL 2005 database, in Windows Authentication Mode?
Jakob
I have to search the keyword from windows application using dtSearch. when user enter the list of keywords in UI, i have to connect to dtSearch tool and based on the output return, the matched keyword should be added to database table.
Now, i have problem in connecting this tool from my application.
Thanks in advance.
Hi,
I have SQLExpress and SQL2005 both installed on my W2K3 server. I can access my databases with SQL2005 without problems.
As far as my memory serves me, I have not made any manual changes to the SQLExpress setup - nor will I as my users will have no knowledge as to how to - it must be an out-of-the-box solution.
I am using VS2005 to create a Windows Form project. I used VS2005 IDE to create a database as MyBookings.mdf . I have, in the IDE successfully created a table. This is all using SQLExpress.
I now wish to access the database and have the following as my connection string:
string connectionString = "Data Source=.\SQLExpress;Integrated Security=True;Timeout=60;Initial Catalog = MyBookings;Application Name=SQLExpressTest;AttachDBFilename=.\MyBookings.mdf";
The following error message is generated when I try to access the db from within my program:
System.Data.SqlClient.SqlException:A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
The SQL log enties for my past several tries are:
007-03-20 09:57:50.92 Logon Cannot attach the file 'MyBookings.mdf' as database 'MyBookings'. [CLIENT: <local machine>]
2007-03-20 09:58:13.92 spid51 Error: 5105, Severity: 16, State: 2.
2007-03-20 09:58:13.92 spid51 A file activation error occurred. The physical file name '.MyBookings.mdf' may be incorrect. Diagnose and correct additional errors, and retry the operation.
2007-03-20 09:58:13.92 Logon Error: 1832, Severity: 20, State: 1.
2007-03-20 09:58:13.92 Logon Cannot attach the file '.MyBookings.mdf' as database 'MyBookings'. [CLIENT: <local machine>]
I have spent 2 days researching this and have come up with no solution.
Can someone help me please.
Thank you.
We have a SQL database on a non standard instance. If I open SQL server manager and connect to that database using integrated Windows Authentication I can basically do whatever I want with that database.However, if I try to connect to that database remotely (or even from the sql server) using a test connection UDL it only works if I use Windows integrated security. If I specify my account details specifically (or any other account which has access) it doesn't want to connect.
View 13 Replies View RelatedCurrently I cannot connect to a database, I got the system.exception €śPlatformNotSupportedExcoption€?. This database is Polish (COLLATE Polish_CI_AS), when I collate this database to latin general it works fine. I connect by using the system.data.sqlclient.sqlconnection, as far as I can see I cannot set the locale identifier here€¦ What can I do???
Thanks for your help!
regards, Jan
I am not able to connect to SQL Database server using windows authentication when I am connected through VPN connection.However I am able to connect to same server using SQL server authentication and also able to do RDP to DB server machine.
I found a resolution in one of the forum suggesting to change UserRasCredentials to 0 value in *.pdk file.Since VPN connection which I am using generates instant proxy this resolution doesn't work.
Also application which I am using does windows authentication connection it is required for me to impersonate windows authetication when connected using VPN.
Hi,
Any one tell me the code to connect to .sdf file in c# windows application?And tell the requirments to conncet.My sdf file path is this
C:\Documents and Settings\koti\My Documents\Example.sdf
I write this code.It is not working
string str = "Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=C:\Documents and Settings\koti\My Documents\Example.sdf;SSCE:Encrypt Database=True";
SqlCeConnection cn = new SqlCeConnection(str);
cn.Open();
Ant one help me Plz...
Regards,
venkat.
Hi,
I am getting an compatibility error when I am installing SQL: Server 2005 on my machine which has WIndos Vista OS.
Regards,
Vicky
I could not change user while attmepting to connvert Integration Services using Windows Authentication via MSSQL MS
any idea? thanks
Hi all,
I'm working on a project where I have to create a password protected form for teachers to submit reports about students.
Originally I was going to use asp.net to create the form, but unfortunately the server I'm working with will not be granted asp functionality in the allotted timeframe.
To solve this issue I have another idea. So I will ask a few questions to help with research before I begin coding.
Is it possible to create a windows application that can connect to an access database hosted online? The windows app will need to be be able to update, insert, and select information from the database.
There is only going to be about 30-40 people using this windows application once or twice a week.
Thus I envision taking a password protected access database and dropping it onto a server.
The windows application will have the online location of the database embeded into the code. (connection string)
From there on out coding for the windows application should be the exact same as if the database was hosted locally on the computer, correct?
Also,
1. What is a good way to check and make sure the computer is connected to the internet before my application tries to access the database?
2. Are there any drastic security issues with this process that I should think about. The database will only be password proected, and the windows application will take a username/password from the user and check it against a table before they are able to submit info to the database.
I just need to be pointed in the right direction for this project.
Thanks.