No Server Found After Installing Sql Server
Mar 22, 2006
sadegh writes "hello
i installed sql server 2005 on my windows xp sp2 os for the first time. but it doesent recegnize any servers and also,no server is listed in registered servers and object explorer.
and also in connect to server dialog box,when i click on browse for more... , it cannot find any local o network servers. ( this is my personal pc and not connected to any networks.)
how can i define a server for the first time?
thank you"
View 2 Replies
ADVERTISEMENT
Jul 20, 2005
HiWhen I attempt to install MS SQL Server evaluation copy (downloadedfrom Microsoft site) on Windows 2K Professional getting followingerror.Setup initialization error.The system cannot find the path specified.Source file or directory missing or cannot be read:'C:SQLEVALx86setup..Systemsqlunirl.dll'Please help.Regards,AG
View 1 Replies
View Related
Feb 5, 2008
I just downloaded the SQL SERVER 2005 TRIAL EDITION. Where to I get the SQL Server Management Studio from? Can I use SQL Server Management Studio Express?
View 6 Replies
View Related
Jan 23, 2007
Does anyone know where I might find this CAB file? Where do I put so the installation can find it?
MSI (s) (58:F0) [16:59:30:375]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI56F.tmp, Entrypoint: StartCache
Action start 16:59:30: StartCache.
StartCache: Error 0x80070490: failed to get cabinet: PA655502.CAB
StartCache: Error 0x80070490: failed to set state for cabinet: PA655502.CAB
I originally posted my problem on 01/19/2007, look for that post if you'd like to see the complete log files.
thanks,
Wnz
View 2 Replies
View Related
Oct 19, 2006
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
Andy
View 1 Replies
View Related
Feb 14, 2007
Hi
I have installed SQL Server Express 2005 on my machine.
I want to install SQL Server Standard Edition 2005 on my machine to check new services it has.
Can these 2 Editions coexist with each other, or any troubles you think might encounter?
Thanks
View 5 Replies
View Related
Sep 10, 2004
When I am trying to create a linked server, I am getting the following error:
Error 6: Specified sql server not found.
I am using 'be made using login's current security contex' option. I have sa access on both servers.
Any ideas?
View 4 Replies
View Related
Apr 26, 2006
We have an application server running Windows Server 2000 with Sp4. When we use the ODBC data sources connection software, it shows the SQL Server 2000 servers in the drop down box, but none of the new 2005 servers. If we enter the 2005 server name and try to connect, we get the 'Specified SQL Server not found' error message. The connection works fine from a newer Windows XP box and remote connections is enabled. My guess is that we need a new ODBC to connect to SQL Server 2005, but I can't find anything that says this.
View 2 Replies
View Related
Sep 20, 2007
While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows...
Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007
Process ID : 5440
E:setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/8/20 11:11:35
Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35
Loaded DLL:E:xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/8/20 11:11:35
Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true
Running: ValidateMinOSAction at: 2007/8/20 11:11:35
Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true
Running: PerformSCCAction at: 2007/8/20 11:11:35
Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true
Running: ActivateLoggingAction at: 2007/8/20 11:11:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
Any ideas?
Thanks in advance.
View 1 Replies
View Related
Apr 21, 2008
Hi,
Is it possible to install SQL Server 2005 Eval on a Virtual PC 2007
client running Server 2008 Beta? Nothing says it isn't possible, it
says I need to service pack it right away, but before it gets started
it comes up with the error 'sqlcu.dll failed to load'. Anyone know
what this is all about?
Any ideas?
Any help would be appreciated.
Thanks!
View 1 Replies
View Related
Sep 21, 2006
COM Plus Catalog Requirement (Warning)
Messages
COM Plus Catalog Requirement
If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
View 6 Replies
View Related
Sep 27, 2006
We've devoted a resource to this today, but I have to believe it's something easy that we're overlooking. The scneario is that we have a production Web application that until last weekend had a SQL 2000 back end. This weekend we installed a new instance of SQL 2005 and everything works (we tested in a sandbox environment, but someone must not have load tested enough) and never saw these exceptions. So, after the upgrade we now receive 100's of thexe SQL excptions per day:A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)Does anyone know what we've overlooked that's causing this issue?Thanks for any help!
View 2 Replies
View Related
Feb 18, 1999
I have tried several times to install SQL server onto an NT4.0 server which is more than capable of having more than one application to cope with, however, when going through the install procedure the programm stops with the following message
DR.Watson
Access Violation
Setup.exe
In address :
Any hints as to where the problems lies or point me inthe right direction would be appreciated.
View 1 Replies
View Related
Feb 25, 2008
I'm trying to install SQL Server 2005 on a server 2000 machine, everything is working with the exception of the Web Service Identity. It is putting machinenameASPNET, and I don't know where to go to make it use something else. I've look around but I have really seen any answers that have worked for me.
Thanks in advance
Will
View 3 Replies
View Related
Feb 25, 2008
Hello:
I just installed Windows Server 2008. The installation also included Web Server.
When I tried to install SQL Server, I got the following warning:
IIS Feature Requirement (Warning)
Messag
IIS Feature Requirement
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
Can somebody advise me on how I can resolve this warning? Would running SP2 take care of this?
Venki
View 18 Replies
View Related
Sep 30, 2005
I am trying to install SQL Server Sep 2005 CTP - ENTERPRISE, there are
View 1 Replies
View Related
May 16, 2008
Hi,
Recently I have installed Visual Studion Team System 2008 Development Edition in my sytem. Along with this, MS-SQL Server aand MSSQL Server Compact Edition is also installed. I need to install the SQL Server 2005 in my system.
In such a scenario, does the Compact Edition is required? Can I uninstall them and install Sql Server 2005 only? If I uninstall anything, would it cause any problems for the .Net programs to work?
Please respond asap.
Thanks for any help.
meeram.
View 1 Replies
View Related
Aug 31, 2007
Hi all, Im new here so il start with a little introduction of myself, My name is Arjan im 19 years old from Holland, and i work for a company to compleet my ICT Education.
My situation:
My boss gave me a server with server 2003 standard and Sql server 2005 and visual studio 2005 installed already, he asked me if i could figure out how the 'new' reporting services work, Im pretty new to SQL and the reporting service but i figured out i had to install asp.net / frameworks and IIS.
So right now i wanna start the Reporting Services Configuration Manager and i get an error that says 'Invalid namespace' and when im trying to approach by using my browser i get 'page not found' so obviously their is Alot wrong. I asked my boss if i could not reinstall everything and do it in the correct order (IIS / ASP.net / Frameworks before installing SQL server 2k5 but that was not an option because we dont seem to have the cd's anymore.
The server is not connected to any network or the internet.
My Question:
Is their any way to fix this? and if yes could anyone tell me where to start
Thanks in Advance!
ps if their is information or logs that u need in order to help me just say so :-)
-Arjan
View 1 Replies
View Related
Aug 2, 2004
Hi
I have inhereted this application and I am a newbee at asp.net.
Fisrt my apologies for posting such a large amount, I just wanted to
give you all the information that I possibly can.
I have the follwoing error "Specified SQL server not found".
Server Error in '/ppasa' Application.
--------------------------------------------------------------------------------
[Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
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.Runtime.InteropServices.COMException: [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.
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:
[COMException (0x80004005): [Microsoft][ODBC SQL Server Driver][DBMSLPCN]Specified SQL server not found.]
ADODB.ConnectionClass.Open(String ConnectionString, String UserID, String Password, Int32 Options) +0
PPASA.PPASA.OpenCloseDB(Boolean Connect) in c:inetpubwwwrootPPASAPPASA.vb:9
PPASA.Login.btnSubmit_Click(Object sender, EventArgs e) in c:inetpubwwwrootPPASALogin.aspx.vb:38
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain() +1277
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573
The process of my application works as follows.
1)Login.aspx submits the username and password. It is linked to Login.aspx.vb with the following statement
<%@ Page Language="vb" AutoEventWireup="false" Codebehind="Login.aspx.vb" Inherits="PPASA.Login"%>
2)In Login.aspx.vb (below) has a call to PPASA.vb with the following statement Call OpenCloseDB(True).
Public Class Login
Inherits System.Web.UI.Page
#Region " Web Form Designer Generated Code "
'This call is required by the Web Form Designer.
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
End Sub
Protected WithEvents Label1 As System.Web.UI.WebControls.Label
Protected WithEvents Image1 As System.Web.UI.WebControls.Image
Protected WithEvents Label2 As System.Web.UI.WebControls.Label
Protected WithEvents txtUsername As System.Web.UI.WebControls.TextBox
Protected WithEvents Label3 As System.Web.UI.WebControls.Label
Protected WithEvents txtPassword As System.Web.UI.WebControls.TextBox
Protected WithEvents btnSubmit As System.Web.UI.WebControls.Button
Protected WithEvents btnClear As System.Web.UI.WebControls.Button
'NOTE: The following placeholder declaration is required by the Web Form Designer.
'Do not delete or move it.
Private designerPlaceholderDeclaration As System.Object
Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init
'CODEGEN: This method call is required by the Web Form Designer
'Do not modify it using the code editor.
InitializeComponent()
End Sub
#End Region
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'Put user code to initialize the page here
End Sub
Private Sub btnSubmit_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSubmit.Click
Dim rs As ADODB.Recordset
Call OpenCloseDB(True)
rs = cnn.Execute("SELECT ID FROM PPASA_User WHERE Name='" & UCase(txtUsername.Text) & "' AND Password='" & txtPassword.Text & "'")
If Not rs.BOF And Not rs.EOF Then
Call PopulateUserInfo(rs.Fields(0).Value)
Server.Transfer("PPASAMain.aspx")
Else
Call ClearLoginBoxes()
End If
Call OpenCloseDB(False)
End Sub
Public Sub PopulateUserInfo(ByVal MyID As Integer)
Dim rs As ADODB.Recordset
Call OpenCloseDB(True)
rs = cnn.Execute("SELECT ID,Name,Security FROM PPASA_User WHERE ID=" & MyID)
If Not rs.BOF And Not rs.EOF Then
rs.MoveFirst()
'CurrentUser.ID = rs.Fields(0).Value
'CurrentUser.Name = rs.Fields(1).Value
'CurrentUser.Security = rs.Fields(2).Value
Session.Add("ID", rs.Fields(0).Value)
Session.Add("Name", rs.Fields(1).Value)
Session.Add("Security", rs.Fields(2).Value)
Session.Add("DonorID", 0)
End If
Call OpenCloseDB(False)
End Sub
Private Sub ClearLoginBoxes()
txtUsername.Text = ""
txtPassword.Text = ""
End Sub
Private Sub btnClear_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClear.Click
Call ClearLoginBoxes()
End Sub
End Class
3)PPASA.vb then creates the connection to the Database. PPASA.vb looks like this.
Module PPASA
Public cnn As New ADODB.Connection
Public Sub OpenCloseDB(ByVal Connect As Boolean)
If Connect = True Then
If cnn.State = 0 Then
cnn.Open("Description=PPASA;DRIVER=SQL Server;SERVER=THE-ONESERVERA;UID=sa;PWD=123;APP=Microsoft Data Access Components;DATABASE=PPASA")
End If
Else
If Connect = False Then
If cnn.State = 1 Then cnn.Close()
End If
End If
End Sub
Public Function CheckSecurity(ByVal Actual As Integer, ByVal Required As Integer) As Boolean
If Actual >= Required Then
CheckSecurity = True
Else
CheckSecurity = False
End If
End Function
End Module
4)After I submit Login.aspx the application boms and gives me the "Specified SQL server not found".
Extra Info:
The Sql server is up and running. I have tested it by connecting with 2 test connection files index.asp and index2 .aspx.
Here are the files. The files also return results from the pubs db.
index.asp
<%
Set conn = Server.CreateObject("ADODB.Connection")
strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
conn.open strConn
sql = "SELECT * from authors"
set rs = conn.Execute(sql)
if not rs.EOF then
while not rs.EOF
lastname = rs("au_lname")
firstname = rs("au_fname")
response.write "LASTNAME :: " & lastname & " \// FIRSTNAME :: " & firstname & "<br>"
rs.movenext
wend
end if
conn.Close()
Set conn = Nothing
%>
and index2.aspx
<%@ Page aspcompat=true %>
<%
Dim objConn
Dim strConn
Dim objRs
Dim objCmd
Dim objField
strConn="DRIVER={SQL Server};SERVER=THE-ONESERVERA;UID=sa;PWD=123;DATABASE=pubs"
objConn = Server.CreateObject("ADODB.Connection")
objCmd = Server.CreateObject("ADODB.Command")
objRs = Server.CreateObject("ADODB.RecordSet")
objCmd.CommandText = "SELECT * from authors"
objConn.open (strConn)
objCmd.ActiveConnection = objConn
objRs = objCmd.Execute
If Not objRs.EOF then
Do While Not objRs.EOF
response.write ("VALUES :: ")
For Each objField In objRs.Fields
Response.Write (" " & objField.value & " \// ")
Next
response.write ("<br>")
objRs.movenext
Loop
End if
objConn.Close()
%>
There are also the following files in the bin directory.
Interop.ADOR.dll
Interop.MSChart20Lib.dll
Interop.Scripting.dll
PPASA.dll
utCharting.dll
So my question is this, why do I get the error "Specified SQL server not found", when I dont get the error with the test connection files.?
Do I have to do anything with the .dll file in the bin directory, like register them or something?
How does the Login.aspx.vb file call the PPASA.vb file when I see no reference to PPASA.vb
in the Login.aspx.vb file?
I would appreciate any help or suggestions.
Thanks
View 1 Replies
View Related
Aug 3, 2004
I have 2 server 2003 boxes one has sql 2000 and the other has IIS. I can pull up my pages on the iis server but as soon as my app tries to access the sql server I get cannot find server. All my settings are correct in the web.config file. I do not have this problem with the same setup on server 2000 boxes. Also active dir is not set up on the 2000 or 2003 boxes. Can someone please help.
thanx
weisenbr
View 3 Replies
View Related
Sep 24, 2004
I am trying to connect to my SQL Server through my ASP.NET webpages. My problem is that, no matter what I do, it always says that the server is not found. I know the IP address of my server, and this IP address works from other computers within my network, just not mine.
I have no idea what it could be. If anyone knows, any help would be greatly appriciated.
Jags
View 5 Replies
View Related
Oct 17, 2005
Hi, i have just started working with asp.net and purchased a book which has MSDE with it for database access. Ihave followed all the instructions on how to install MSDE, however when i try to set up a database using Miscrosoft ASP.NET Web Matrix, i get the error message:Unable to connect to the database server.SQL server does not exist or access denied.ConnectionOpen(Connect()).This message occurs when i am creating a new database.does anyone have any ideas why this may be happening?I have MySQL installed on my computer, could this be interfering with the MSDE ?Thanks....
View 2 Replies
View Related
Dec 15, 2001
please help me!!!
I have trouble connecting...
and i get get this error when i try to connect to my server:
Specified SQL Server not found
what to do? what to do??
robert
View 1 Replies
View Related
Dec 21, 1999
Hi,
Sometimes when I try to connect to an existing server (sql 7.0) , I get the error message "specified sql server not found-check registration properties" and it refuses to connect to it.
Has anyone encountered this before? Do help.
View 2 Replies
View Related
Dec 21, 2001
I'm attempting a connection to my sql server (running off broadband) from a page I have hosting at my new ISP.. just a standard conn string in .asp..
cn.Open "PROVIDER=SQLOLEDB;DATA SOURCE=24.10.XX.XXX.UID=sa;PWD=mypwd;DATABASE=d_ap p;"
and i get "[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found."
From my older host I have no problems connecting to my server... so I assumed it must be something at my new host, but I'm able to connect to other remote sql servers from my new isp (for example I can connect from my new ISP to the old ISP's SQL server w/o a problem), but for some reason I can't from the new host connect to mine.. is there a setting on mine that needs to change?
newhostwebsvr to oldhostsql works... oldhostwebsvr to mylocalsql works.. newhostwebsvr to mylocalsql doesn't work??
View 1 Replies
View Related
Apr 26, 2002
Hi there,
I access to server SQL by an application on web,I configured the ODBC box for using TCP/IP and the server use also the TCP/IP.
I have this message :
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][Named Pipes]Specified SQL server not found.
/medecin/IdentificationAcces/membre_enregistrer.asp, line 108
I don't know why there is Named Pipes in message.
Please help me
thanks in advance
Jalal
View 1 Replies
View Related
Apr 2, 2007
when trying to install SQL Sever 2005 to windows server 2003 its display the message Windows Installer 3.1 is required. But when tring to install windows installer 3.1 is displays the message Service Pack version of newer than the update that you are applying, Ther is no need to install the update. Why?
View 1 Replies
View Related
Jun 8, 2006
Is there a problem doing this or will it run fine.
View 1 Replies
View Related
Oct 12, 2006
Hi,I was hoping someone may be able to shed some light on a SQL2000 connection problem.I have an ASP.NET(1.1) application that connects to a SQL2000 instance on the localmachine, the connection details are as follows: Connection Code :try
{//connect to the provided datasource
using(SqlConnection connection = new SqlConnection(strConnectionInfo))
{
strStatus = "Pulling Data";
SqlDataAdapter sqlA = new SqlDataAdapter("SELECT * FROM NavBlocks",connection);
sqlA.Fill(dsNav.NavBlocks);
SqlDataAdapter sqlB = new SqlDataAdapter("SELECT * FROM NavItems",connection);
sqlB.Fill(dsNav.NavItems);
bNavLoaded = true;//prevent further calls
}
}The connection string is as follows: "Data Source=BOBBITSQL2000;Initial Catalog=pinnacleCMS;User Id=myUser;Password=myPass;"Now this conection has never been a problem, the intial catalog exists, the user exists and has permissions, further to this this users connection details can be used to succesfully access the database from a dsn on this machine. The server explorer finds the database fine, Visio finds the databse fine.The problem only existed after I reverse engineered the database into visio (the database was originally developed using Visio), then dropped all of the tables using Enterprise Manager, and re generated the database from within Visio (ddl script) following a few minor changes.Since the re generation I get the server not found error message from the ASP.Net application.I have tried using different network libraries, logging in using the sa account etc, it makes no difference the ASP.Net application cannot see the SQL server instance.Any ideas would be greatly appreciated.p.s. I have tried dropping the firewall with no success, no updates have been installed.Thanks
View 7 Replies
View Related
Aug 7, 2006
Yesterday I created a table in Sql Server 2000,using this script：
CREATE TABLE [dbo].[User](
[Id] [int] NOT NULL,
[UserName] [nvarchar](20) NOT NULL,
[TrueName] [nvarchar](20) NOT NULL,
[Password] [nvarchar](60) NOT NULL,
[Department] [int] NOT NULL,
[Mobile] [nvarchar](20) NULL,
[Telephone] [nvarchar](20) NULL,
[Remark] [nvarchar](200) NULL,
[Enabled] [bit] NOT NULL,
[Available] [bit] NOT NULL,
CONSTRAINT [PK_User] PRIMARY KEY CLUSTERED
(
[Id] ASC
) ON [PRIMARY]
) ON [PRIMARY]
There was only one record in it:
INSERT INTO [User] VALUES(1,N'SUP',N'Jim',N'213123',1,NULL,NULL,NULL,1,1)
After I executed this script：UPDATE [User] SET UserName=N'f',TrueName=N'gg',[Password]=N'dfsdfsdf',Mobile=NULL,Telephone=NULL,Remark=NULL,
Enabled=1 WHERE [Id]=1 AND Available=1
The value of 'Available' field changed to Zero.That was not supposed to happen.
I'm pretty sure it is a bug, because when I did the same thing in Sql Server 2005, everything was correct.
Anybody can tell me if this is a known bug? I searched google,but couldn't find any answer.
Thanks!
View 6 Replies
View Related
Sep 30, 2004
When making a call to MyList.DataSource = products.GetProductCategories();
I get the "SQL Server not found or Access denied" error. Where should I start looking?
Thanks,
Dion
View 2 Replies
View Related
May 30, 2001
Hi,
Can any one suggest me how to find a error log when SQL Server Agent is down. I did not find it in NT error log when my SQL Server Agent was shut down. Is it known problem and pls also suggest me for the remedy to this problem.
thanks in advance.
regards,
Narayanan.
View 1 Replies
View Related
May 28, 2008
I have just installed sql server 2005 express, and ssmse..
have created the db, and can work in the management studio writing queries,etc.. all is fine..
when i try to open my proprietary exe i get the error of
"SQL SERVER NOT RUNNING OR DATABASE CANNOT BE FOUND" Now, I know the DB is there, and I know SQL is runnig.. what could it be?
any ideas and thanks in advance..
View 10 Replies
View Related
