Complete Lack Of Database Connectivity
May 9, 2008
A couple of days ago I installed SQL Server 2005 developer. To pave the way for this I removed SQL Server 2000 and 2005 Express.
Since then I've been unable to connect from any of my applications or websites in Visual Studio 2005 to either:
- my new 2005 Developer database engine
- my colleagues 2005 developer database engine.
My colleague can connect to my databases from his visual studio on his machine.
I am receiving unspecified OleDb errors.
Anyone else had this happen? Anyone know where I should start looking?
I've uninstalled all .Net frameworks and re-installed 1.1 and 2.0.
Many thanks,
Sam
View 3 Replies
ADVERTISEMENT
Jul 23, 2005
Dear All,We have a procedure that takes12 minutes to run on the first server butthat same procedure now takes 3 hours to run on the second server using thesame data. Does anyone have any suggestions why this is happening and howto make the procedure faster on the second serverThanks in advance.Jeff Magouirk
View 1 Replies
View Related
Jun 15, 2006
how can i copy a complete database (tables, views, stored procedures) with/in the sql server 2005 "server mgm. studio". the import/ export function only copys the data (tables).
sql server 2000 had a nice tool for that (import/ export data). but how can i do that with the sql server 2005. can't find anything ...
View 3 Replies
View Related
Nov 22, 2007
Hello all! A while ago I started cataloging my collection of old radio recordings and I wrote a simple Visual Basic 2005 program to display them in a nice UI. I have implemented an SQL database with the project and all is fine, when I run the program it connects to the sql server and downloads the data. But when I try and change something by connecting from within Visual Basic at runtime with this code:
Private Sub Save_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Save.Click
Dim ConnectionString As New SqlConnection("Server=MARK-HOMESQLEXPRESS;Database=Library.mdf;Uid=MARK-HOMEMark;Pwd=sodoff;")
Dim sqlString As String
ConnectionString.Open()
sqlString = "UPDATE JackBenny SET Rating='Excellent' WHERE [Episode Number]=" & epNumber
ConnectionString.BeginTransaction(sqlString)
ConnectionString.Close()
End Sub
I get this error code in the log and a general unable to login error within Visual basic itself:
2007-11-22 15:44:39.78 Logon Error: 18456, Severity: 14, State: 5.
2007-11-22 15:44:39.78 Logon Login failed for user 'Mark'. [CLIENT: <local machine>
The state of 5 refers to "User ID is not valid." but I can login to SQL Server Management Studio Express just fine with the username and password in the code posted. Also of note, I can login to the Server Managment with the sa account username and password. When I use the credentials in visual basic code, same error. Any ideas? I am trying to connect to a database which is on this computer (local) in the root folder of the application, called Library.mdg.
Thanks so much all
View 7 Replies
View Related
Nov 12, 2007
Hi,
How can I encrypt / decrypt whole database (data, objects ... everything) in SQL Server 2005 Express Edition?
Quick solution from any champion of Databases would be highly entertained.
Waiting ..
Thanks a lot.
View 4 Replies
View Related
Oct 26, 2006
Hello,
I want to truncate all tables present in the particular database, Is there any simple way to do it? or do I have to do it on individula basis (table by table)?
regards
View 4 Replies
View Related
Mar 19, 2007
Facundo writes "Hi:
How can i add a timestamp to a generated file of a complete database backup, the idea is to archive full database backups using the date to identified it.
Thanks a lot.
FB"
View 1 Replies
View Related
Oct 9, 2006
Is there any way of getting the queue, service, message being processed by service broker whilst monitoring with profiler?
View 2 Replies
View Related
Jul 20, 2005
HiI have have two linked SQL Servers and I am trying to get remote writesworking correctly (fast).I have configured the DB link on both machines to:Point at each others DB.I have security set up to map each others server loginsand Server Options: Collation Compatible, Data Access, RPC, RPC Out, UseRemote Collation all checkedMy problem is that when a SP performsBegin TransactionUpdate Local TableUpdate Remote TableCommit TranIt takes several seconds to complete. (about 7 seconds not acceptable tous)This is due to the remote update - how can I improve the response time?example of a stored procedures that takes timewhere ACSMSM is a remote (linked) SQL Server.procedure [psm].ams_Update_VFE@strResult varchar(8) = 'Failure' output,@strErrorDesc varchar(512) = 'SP Not Executed' output,@strVFEID varchar(16),@strDescription varchar(64),@strVFEVirtualRoot varchar(255),@strVFEPhysicalRoot varchar(255),@strAuditPath varchar(255),@strDefaultBranding varchar(16),@strIPAddress varchar(23)asdeclare @strStep varchar(32)declare @trancount intSet XACT_ABORT ONset @trancount = @@trancountset @strStep = 'Start of Stored Proc'if (@trancount = 0)BEGIN TRANSACTION mytranelsesave tran mytran/* start insert sp code here */set @strStep = 'Write VFE to MSM'updateACSMSM.msmprim.msm.VFECONFIGsetDESCRIPTION = @strDescription,VFEVIRTUALROOT = @strVFEVirtualRoot,VFEPHYSICALROOT = @strVFEPhysicalRoot,AUDITPATH = @strAuditPath,DEFAULTBRANDING = @strDefaultBranding,IPADDRESS = @strIPAddresswhereVFEID = @strVFEID;set @strStep = 'Write VFE to PSM'updateACSPSM.psmprim.psm.VFECONFIGsetDESCRIPTION = @strDescription,VFEVIRTUALROOT = @strVFEVirtualRoot,VFEPHYSICALROOT = @strVFEPhysicalRoot,AUDITPATH = @strAuditPath,DEFAULTBRANDING = @strDefaultBranding,IPADDRESS = @strIPAddresswhereVFEID = @strVFEID/* end insert sp code here */if (@@error <> 0)beginrollback tran mytranset @strResult = 'Failure'set @strErrorDesc = 'Fail @ Step :' + @strStep + ' Error : ' + @@Errorreturn -1969endelsebeginset @strResult = 'Success'set @strErrorDesc = ''end-- commit tran if we started itif (@trancount = 0)commit tranreturn 0
View 2 Replies
View Related
Oct 2, 2006
Hi,I've read that SQL Server 2005 ED lacks 'enterprise feature support'. What does this mean?
View 5 Replies
View Related
Jan 21, 2008
hi,
how to connect the database for first time
iam working for a website in that i have a form. how to connect the form to the database.
throw enterprice managment
thanks
View 1 Replies
View Related
Jul 26, 2005
Hi im new to ASP.NET.. can anyopne pelase tell me how to make database connectivity with sql server 2000.i need to insert data into sqlserver2000 database from an ASP.NET Web form. please provide me with a asample code.thank you
View 1 Replies
View Related
Jan 11, 2006
I am using SQL SERVER 2000 and asp.net How shoul i connect using OLEDB provider?.
In connection string, i am giving Provider=SQLOLEDB.1,datasource .
It's giving error in conn.open() that login failed for database. i am also poroving username and password in connection string, so i want code for the same.
awaiting for reply...
View 2 Replies
View Related
Apr 9, 2007
Hello
I'm using Visual Studio 2005 and want to connect my C# application to a SQL mobile database. So far I have added one via Project->Add component and can create tables and manipulate fields.
Howver I can't manage to manipulate it via my code. All I seem to be able to access is a <database name>DataSet object and I cant see how that helps. Do I need to import any new libraries? I'm familiar with datasets with VBA so was expecting something similar.
Any advice?
Thanks
Paul
View 1 Replies
View Related
Nov 22, 2007
We are trying to setup a role based security access within our client software so that users have read only access to the database. Right now we are not able to connect to the database. This is a blocking issue for us on the project right now
Please let us know how to proceed now ?
Thanks in advance
Kishore
View 6 Replies
View Related
Jan 29, 2015
Script: [URL] ....
I need to move all of the contents of one database into anther with the same schema, and it looks like this might be just what I need. But it is from 2007, so I wonder if it is still current?
Also, having tried to run it on another database to generate the script that will actually do the copying, I have a few questions. It looks like it generates statements to import the data twice. For example:
BULK INSERT [TaPerfGDB].[dbo].[i1]
FROM 'C:Tempi1.Dat'
WITH (FORMATFILE = 'C:Tempi1.FMT',
BATCHSIZE = 1000000,
ERRORFILE = 'C:TempBI_i1.ERR',
TABLOCK);
And a little later:
INSERT INTO [TaPerfGDB].[dbo].[i1]
SELECT *
FROM OPENROWSET(BULK 'C:Tempi1.Dat',
FORMATFILE='C:Tempi1.Xml'
) as t1;
That does not really make any sense to me. It also generates statements like this:
bcp "[TaPerfGDB].[dbo].[GDB_GEOMNETWORKS]" format nul -n -CRAW -f "C:TempGDB_GEOMNETWORKS.fmt" --S"PGALLUCC-M7" -T
What is the deal with the double hyphen by the servername? Won't it just see that as a comment? It can be easily fixed, but I am just suprised that it is still there after all these years. My purpose in doing this is a desparate attempt to salvege a database that sits on a server with multiple drive errors. These prevent backups, so I cannot just restore the database on the new server. That is why I want to try an approach that goes table by table, so that at least all the tables which are not touched by the drive errors can be moved.
It is a 3 TB database running on SQL Server 2008 R2 std. ed.
View 2 Replies
View Related
Jan 17, 2006
Hello,
I've been trying for a couple of days now with the following problem in SQL
Ive a table called tblRresults that has the following
Date - just a regular date
OfficeLocation - just a unique id such as a zip code
SampleType - contains things like wall, floor, beam
SampleResult - "Detected" or "NotDetected"
When populated the table can look like
12/12/05 99505 Wall Detected
12/12/05 99505 Wall NotDetected
10/04/05 99211 Beam Detected
10/04/05 99211 Beam Detected
10/04/05 99111 Floor NotDetected
10/04/05 99111 Floor NotDetected
What I want is (I guess) a crosstab query that produces the following
Date Location SampleType CountDetected CountNotDetected
12/12/05 99505 Wall 1 1
10/04/05 99211 Beam 2 0 (or null would be ok)
10/04/05 99111 Floor 0 2
Any help gratefully accepted, this has been driving me mental!
thanks
View 2 Replies
View Related
Mar 2, 2008
1) if our .net app (oltp) is changed to ask sql for encryption (rather than thru .net) on server A, can server B where our wh resides, thru a linked server run an sp remotely on A and get A to provide decryption thru the keys defined there?
2)can the encryption keys etc defined on one server be imported to another server and still behave exactly the same way on the 2nd server as they do on the first? ie decrypt data originally encrypted by the first successfully.
View 4 Replies
View Related
Apr 18, 2007
i am in the process of creating some new reports on a new Reporting Services site
reports developed in VisualStudio2005 pointing an an AnalysisServices Cube on a (development) SQL2005 database
when i Preview the reports in Visual Studio 2005 on my development box, the reports take about 12-15 seconds to run (about 4-5 seconds before the "Report is being generated" logo appears, then another 8-10 seconds before the report appears (report is a series (1-8) of charts))
when i run the same report (with the same report criteria) via the Report Manager (pointing at the same AnalysisServices Cube), it now takes about 45 seconds to run (about 15 -16 seconds before the "Report is being generated" logo appears, then another 30 seconds before the report appears)
(n.b. this is not due to initial Report Manager start-up delays, the timings are for the second and third run of the report)
can anyone out there point me in the direction of where to look ??
View 1 Replies
View Related
Jan 17, 2007
I'm trying to connect to a database to carry out a simple task but my connection keeps returning the error
Login failed for user 'myComputerNameASPNET'.
I can use the same connection string to connect from both a desktop app and a web service. I can even connect using the same code while in debug and stepping through the code line-by-line. And yet when I run the web page normally I get the above error. Why is this?
I've tried several connection strings but they all return either the above error or "Not associated with a trusted connection".
View 1 Replies
View Related
Mar 24, 2008
Dear Sir,
Recently I had hosted a web site, and I had tested a database connectivity to check. After giving the connectivity to the database it had given me the following error:
Server Error in '/' Application.
The connection name 'masarad_jagdishConnectionString1' was not found in the applications configuration or the connection string is empty.
The source code that generated this unhandled exception can only be shown when compiled in debug mode. To enable this, please follow one of the below steps, then request the URL:1. Add a "Debug=true" directive at the top of the file that generated the error. Example: <%@ Page Language="C#" Debug="true" %>or:2) Add the following section to the configuration file of your application:<configuration> <system.web> <compilation debug="true"/> </system.web></configuration>Note that this second technique will cause all files within a given application to be compiled in debug mode. The first technique will cause only that particular file to be compiled in debug mode.Important: Running applications in debug mode does incur a memory/performance overhead. You should make sure that an application has debugging disabled before deploying into production scenario. Stack Trace:
[InvalidOperationException: The connection name 'masarad_jagdishConnectionString1' was not found in the applications configuration or the connection string is empty.]
System.Web.Compilation.ConnectionStringsExpressionBuilder.GetConnectionString(String connectionStringName) +3047985
ASP.data_aspx.__BuildControlSqlDataSource1() +81
ASP.data_aspx.__BuildControlContent1(Control __ctrl) +106
System.Web.UI.CompiledTemplateBuilder.InstantiateIn(Control container) +12
ASP.masterpage_master.__BuildControlContentPlaceHolder1() +105
ASP.masterpage_master.__BuildControlform1() +196
ASP.masterpage_master.__BuildControlTree(masterpage_master __ctrl) +106
ASP.masterpage_master.FrameworkInitialize() +45
System.Web.UI.UserControl.InitializeAsUserControlInternal() +31
System.Web.UI.MasterPage.CreateMaster(TemplateControl owner, HttpContext context, VirtualPath masterPageFile, IDictionary contentTemplateCollection) +2028700
System.Web.UI.Page.get_Master() +48
System.Web.UI.Page.ApplyMasterPage() +18
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint
My connection in the web config file given is correct. I check the test connection is was also successful
My web site link is as follow
http://www.masarada.com/hardware.aspx after opening the site click on the hyperlink:-database.
kindly help me in this regard.
B.Jagdish Rao
View 2 Replies
View Related
Mar 25, 2008
Hi All,
I am a beginner in ASP.NET and trying to access sql database from using C# language thru ASP.NET . I hv tried with below code but could not able to make out. connection = new SqlConnection("Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=ServerName;");
connection.Open();
dataadapter = new SqlDataAdapter("select * from customers", connection);dataset = new DataSet();
dataadapter.Fill(dataset, "table1");
DataGrid1.DataSource = dataset;
DataGrid1.DataMember = "table1";
Am getting the error -
System.Data.SqlClient.SqlException: Login failed for user 'ServerNameASPNET'.
Please help.
View 10 Replies
View Related
Jul 20, 2005
I am using java applications to connect to my MS SQL Server database.I am using ODBC for database connectivity.If i am running my java applications in a remote PC and try to connectto database server, unless i login to theserer, i am unable to connect to database.If a login to database server with it's username and password, thenthe database is getting connected.It is not correct to login to database server for databaseconnectivity.what is the solution for this?
View 1 Replies
View Related
Jul 31, 2007
Dear SSIS experts,
I was wondering if there's such a thing that we could assign the database connection on the fly dynamically? so that I save the connection string or the database name somewhere and SSIS reads it on load time or something..
Thank you
View 4 Replies
View Related
Nov 3, 2014
I need to connect database engine through SQL Server Authentication and want to disable connectivity through Windows Authentication. Only wanna connectivity through SQL Server, if this is possible then how to proceed further?
View 6 Replies
View Related
Dec 6, 2007
Hi,
A third party development company is creating a third party application for us in PHP and uses a MYSQL database. The app is an extension of our website which is developed in .NET and uses a MSSQL 2005 database. There are some cases where the two databases require connectivity since a few fields need to relate. We are having issues connecting the two databases on the server and after reading some forums have identified it to be a configuration issue.
I was wondering if anyone could be of any help in solving this issue, or lead us in the right direction (i.e. where to begin, forums, etc.). Here is a description and some questions from our developer:
---------------------------
We are trying to get a PHP application (.php pages running on the webserver which is the same physical machine as the MS SQL server) to connect to the database (MS SQL server). In order to facilitate this, php.ini was configured in the following manner:
mssql.secure_connection = ON
extension=php_mssql.dll
We ensured that IIS/Windows was setup properly too:
System32 and php both contain ntwdblib.dll ver 2000.80.194.0
enable pipe name protocol [Default was disable]
enable TCP/IP IP1 [Default was disable]
MS SQL Server is set to Windows AND SQL server authentication (Mixed mode).
When the PHP application attempts to connect to the database by using:
mssql_connect('localhost', '<userid>', '<password>')
produces this error message:
Login failed for user 'MAILIUSR_<computername>'. (severity 14)
Why doe this occur? Why is this IUSR userid being used? the userid we sent in with PHP was a sql userid that we know works (we use it with .NET, and to connect to the database remotely). Also, why is it using the MAIL domain? In anycase, shouldn't this IUSR userid work? it's a valid windows account, and mixed mode authentication is allowed.
-------------------------
Any assistance would be greatly appreciated!
View 2 Replies
View Related
Oct 19, 2005
Dear all,I am having trouble connecting my asp.net pages to a sql server database.I have the database running in visual studio and i can query it using the sql pane.My problem is that i don't know where to put the ADO.net query string or what it should look like.Does visual studio provide a wizard for doing this?Also is it possible to use CSS to change ASP.NET tags, i.e. asp:LabelAny help would be appreciated.Cheers
View 4 Replies
View Related
Jan 9, 2008
Hi,
Im trying to connect IBM U2 XML Database using my ms.net Server explorer.but server not itself getting detected.
Prerequisites :i have installed the following things in my system
1. U2 on my machine and created databaes and tables.
2. IBM Database Add-ins for Vs.net 2005
below are the following steps im trying to connect IBM U2 Xml Database
1.Server Explorer ->Addconnection
Datasource : IBM DB2,IDS and U2 servers
2.in server tab its not showing my server which created using U2
Can any one please guide me in this issue
View 3 Replies
View Related
Dec 5, 2007
We recently had a problem were a webserver lost connection to sql 2000 database after we put in a new router. When we failed back to old router it was able to connect to database again. It is using a non standard port 2125 to connect to sql database. Why would a new router cause connection problems to a database.
View 4 Replies
View Related
Jun 12, 2007
hai,
I am working on ASP.NET 2003 with SQLServer2000. My application requires to be connected to the Database which is there in my Headoffice.
My SQLServerName is "MyDBServerTestDB"
Database Name is "WebTO", UserID="******" and Password="******"
My Remote Server IP Address is "192.168.1.2" and its Static IP is "58.93.61.235"
I have specified the Connection string for my Remote Server as
"Provider=SQLOLEDB.1;Server=58.93.61.235TestDB;UID=******;PWD=******;Database=WebTO"
(or)
"Provider=SQLOLEDB.1;Server=58.93.61.235TestDB,1433;UID=******;PWD=******;Database=WebTO" (1433 is the Port number of the Remote SQLServer)
but it is giving the error " SQL Server does not exist or access denied".
if i execute the same application at my Headoffice (Remote Server) by changing the Connection string as
"Provider=SQLOLEDB.1;Server=192.168.1.2TestDB;UID=******;PWD=******;Database=WebTO"
then, it is working fine.
Can anyone tell me where i went wrong or what i have to specify in my Connection string so that i can access my Remote Database Server.
Thanks in Advance,
Srinivas.
View 7 Replies
View Related
Nov 7, 2006
Hi, I'm using SQL Express to run DotNetNuke on my own Windows 2003 server. DotNetNuke(DNN) copies a database on to the server from it's installation files and during the installtion process it fills the database with starter data. That process works fine.
But the minute I attach to the database in SQL Server Management Studio Express (MSE), my web app loses connectivity to the database. When browsing to the default.aspx, I see the following message:
Error Installing DotNetNuke
Current Assembly Version: 04.03.05
ERROR: Could not connect to database specified in connectionString for SqlDataProvider
__________________________________________________________________
(don't be fooled by the error message, Dot Net Nuke was fully installed and working before I attached to it with Management Studio Express)
Does anyone know the trick to getting the asp.net app talking to the database again? I'm using Windows Authentication. I have verified that Management Studio Express is what is messing up my connection. Any help is appreciated.
I have already become aware that I must disconnect from the database (in Management Studio Express) for the web app to connect properly. I have already tried that. Same error. So far for me, it seems that simply attaching to the database with Management Studio Express breaks my database connectivity.
View 7 Replies
View Related
Apr 17, 2014
We are in web site development company,Previously we don't have proxy configuration, after implementing Proxy , we have an issue to connect a remote database.
The error pops "A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. Error 53".
View 1 Replies
View Related
Aug 4, 2007
Backup failed to complete the command backup database [ ] TO VIRTUAL DEVICE = ' { 853D3FC0 - 45EA -85B1 - 54F0EA379CAC } 24 ' WITH SNAPSHOT , BUFFERCOUNT = 1 , BLOCKSIZE = 1024
View 1 Replies
View Related
