So I keep up with what MS are doing, it's my job.
I download the beta versions to have a look.
Then I try to install SQL Express an it tells me I have the remains of beta versions.
I look in A&R no signs of the beta version left.
What can I do?
Looks like I'll be Mygrating to MySQL.
Why do I feel like MS is always taking PESH!!!
A whole bunch of exciting new stuff announced around the Visual Studio Express Editions today. VS Express is now free for good, not just 1 year (just like SQL Server!). Also lots of great new content and fun projects to do.
See Dan Fernandez's blog posting at http://blogs.msdn.com/danielfe/archive/2006/04/19/579109.aspx for lots of details.
Best, MJ
Do you believe that SqlServer Express can work absolutely without any administration?
That is to say: my clients are people without any technical knowledge and they usually communicate never with me.
Is SSE the correct database for this status, or should I use a desktop database like VFP or Access?
When I run the install script, I always get a warning that the hard drive (space?) won't support the install, but I have installed successfully with the new tools etc. and I still have 20 gigs left on my laptop. Why is this warning given?
thx,
Kat
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
Please tell me what I am missing here. I've got an XP Pro machine with SQL Server Express running and a laptop with XP running the Management Studio Express. This is on my home network which is wireless. I can't see any databases on the XP Pro machine from the laptop. Is there something besides just installing SQL Server that I need to do? I've checked forums, documentation and co-workers but no luck. Thanks in advance
View 2 Replies View RelatedI am trying to install SQL2k5 Express on a Win 2k server.
The install throughs an error during the "native client" setup, saying it is missing a MSI for it. I have verified via checksum that the download from MS is correct.
Have any of you guys had this error ?
Hi,
How do I create a new instance for SQL Express? Also the machine also has MSDE Installed if that should be taken into consideration.
Thanks.
Hi,
I just installed SQL 2005 express. It did not prompt me for a selection for the collation. How do I tell what collation it is installed at? And how do I tell whether it is case sensitive or not?
Thanks,
Razzle
Hi,
I am installing SQL Server 2005 on a server that is currently running SQL Express. My reason for installing full SQL is due to the database size limitation of SQL Express.
Can anyone give me advice on whether I should unistall SQL Express before installing SQL Server 2005 or just install over the top of Express.
Thanks
Hello
I have SQL Express with Advance report tools installed. I have download the express toolkit to use the Business Intelligence, however after I have installed the add on, when ever I select the Musiness Intelligence Management Studio I have a browser looking for the file Devenv.exe file and a reinstall is not working.
Can anyone help with this?
I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases.
However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed.
Could I have downloaded the wrong package?
hi, Im trying to install SQL express 2005 on my Desktop Computer and I keep running into the error "Setup has detected a problem with Microsoft .Net Framework installation and cannot proceed .Net Framework 2.0 is either not installed on this system or is corrupt"
when infact it is installed.. any sugestions?
By the way im Running Windows X64 Pro with a AMD athlon X2 3800+ CPU and 2GB of Corsair DDr2 ram
I am having a problem installing SQL Server Express 2005 from the command line in that it gets part way through and then stops - no message - just terminates. After much rooting around in log files and running a normal install I'm pretty sure that it is stopping because of a warning regarding "Minimum Hardware Requirements".
The laptop I'm trying to install it on is a Samsung X05, Centrino 1.4, 1gb RAM and 60gb free disk space. I've tried it on another laptop (Sony with a higher spec.) and get exactly the same problem.
As far as I can see the hardware spec is well above the recommended minumum so I'm at a loss as to what to try next to overcome the problem. If anyone has any suggestions then I'd be very grateful.
When trying to install SQL Server 2005 Express, it hangs up on "Detecting Installed IIS". This happens if I have IIS installed, and if I do not. My computer is running XP Media Edition. I found a similar question asked by flashg on these forums, but there was no answer to the problem. There were a few other people who posted the same problem.
Is there any fix to this? I am writing software that I planned on using SQL Server Express to store its data with. But if SQL Server is going to cause problems on my customer's computers then I cannot use it.
This is the end of the log file for my SQL Server installation:
MSI (c) (00:20) [20:47:22:140]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (00:04) [20:47:22:140]: Invoking remote custom action. DLL: C:DOCUME~1KYLEOL~1LOCALS~1TempMSI1AA.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (00!60) [20:47:22:155]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Wed Oct 18 20:47:22 2006
<Func Name='CheckIIS'>
Action 20:47:22: CheckIIS. Detecting Installed IIS
MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
So, I read this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=416220&SiteID=1, which suggested that I could call SQLEXPR32.EXE (the SP2 download) with the relevant commandline args in exactly the same way I could call setup.exe. Namely, if I were to call:
Code Snippetsetup.exe /qb /settings "c:/setup.ini"
then I should be able to use
Code SnippetSQLEXPR32.exe /qb /settings "c:/setup.ini"
where my setup.ini contains
Code Snippet[Options]
ADDLOCAL=SQL_Data_Files,SQL_Replication,Connectivity
INSTANCENAME=AuctionI
SAPWD=auctioni_000
SECURITYMODE=SQL
However, this doesn't seem to be working at all - the commandline params to SQLEXPR32.EXE are completely ignored, and it runs as if they were not specified.
Would be great to get some help on this. I'm equally happy with the set of commands I need to call in order to extract SQLEXPR32 and then run setup, but SQLEXPR32 seems to extract to a random GUID dir, and automatically start setup, neither of which is condusive to automating it.
Thanks,
Dan
I have installed SQL Server Express on a Windows XP Professional workstation. The installation instructions that I was following said that I had to have .NET Framework 2.0 installed. The instructions said that I should uninstall any versions before I tried to install 2.0. My computer already has version 2.0 and version 3.0 installed, so I did not remove anything.
My problem is that now that I have SQL Express installed I cannot seem to connect to anything. I was specifically trying to convert an Access database to SQL Server format, and I keep getting a "connection failed" error. I don't seem to have any way to start SQL Express. Does it have to be started or is it running by default? What am I doing wrong?
Hi,
I was trying to install visual studio 2005 and as part of it I wanted to install sql express as well. It installed the rest okay but not the sql express. Going through the log file I figured out that there was some incompatible beta version installed and hence had to be removed. In the log file I got the following error messages. Going through the forum suggestion I was trying to use msiexec /x to deinstall each of them but got the error message that "The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is unable to write property into cache: flagCommit. Unable to write property into cache: "flagCommit" XmiRW Error: Failure loading xmlrw.dll CheckAllProcedures. returned 2". After this error message when I check the sql server configuration manager, I still see the old instances running.
I followed up another forum suggestion where I completely installed the old CTP and used the tool provided in the DVD(sqlbuw) to uninstall it but it only removes the one instance and leaves the rest on the system.
I will really appreciate help...
ERRRR:...
icrosoft SQL Server 2005 Setup beginning at Sun Nov 19 16:49:19 2006
Process ID : 5736
c:87450d2367f159d42610acad33156dbcsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/10/19 16:49:18
Complete: LoadResourcesAction at: 2006/10/19 16:49:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/10/19 16:49:18
Loaded DLL:c:87450d2367f159d42610acad33156dbcxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/10/19 16:49:19, returned true
Running: ValidateWinNTAction at: 2006/10/19 16:49:19
Complete: ValidateWinNTAction at: 2006/10/19 16:49:19, returned true
Running: ValidateMinOSAction at: 2006/10/19 16:49:19
Complete: ValidateMinOSAction at: 2006/10/19 16:49:19, returned true
Running: PerformSCCAction at: 2006/10/19 16:49:19
Complete: PerformSCCAction at: 2006/10/19 16:49:19, returned true
Running: ActivateLoggingAction at: 2006/10/19 16:49:19
Complete: ActivateLoggingAction at: 2006/10/19 16:49:19, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5736" returned false.
Running: PerformSCCAction2 at: 2006/10/19 16:49:19
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2373A92B-1C1C-4E71-B494-5CA97F96AA19}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{CD080F4B-BF2C-4A0E-B923-CDA7F6EAB1C9}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{481DFF26-7C67-4085-9A27-758283EA494A}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"
Product "{90032DD0-ABEE-4424-AC1E-B076BDD4E350}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Tools CTP"
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032
I previously installed and uninstalled SQL Express on my laptop. The second time when I try to reinstall SQL Express, it gives me an error and hault the installation.
Here is the error message:
An installation package for the product Microsoft SQL Server Native Client cannot be found.Try the installation again using a valid copy of the installation package 'sqlncli.msi'.
Does it mean the setup file is corrupted or something else is causing the error.
Please help, thank you.
I have just installed Sql Express
But one installed all I have available to me is
Sql Server Config Man
Sql Server Error reporting Usage
Surface area config
IDoes any one know how to get the other features like the databases and reporting installed
thanks for any help Sammy
I recently posted this question in the SQL Server Express forum and it was suggested I also post this issue to this forum. In the hope that someone can shed some light on the problem.
A couple of days ago I installed SQL Server Express and it seemed to be running fine. (I've not really had a lot of time to devote to trying it out).
Today I decided to remove the software as I noticed it placed various components on differnet drives (my fault, I think). Anyway I removed everything using Add/Delete Progams and then deleted any folders left behind.
Now I try a fresh install of SQLEXPR_ADV and I get as far as the "Instance Name" dialog and use the default Named instance of SQLEXPRESS and then click Next.
The next dialog box appears with the heading "Existing components". The three check boxes are grayed out. So I click the Details button and the following is presented on screen:
Name: Microsoft SQL Server 2005 (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
Name: Microsoft SQL Server 2005 Reporting Services (SQLEXPRESS)
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
Name: Microsoft SQL Server 2005 Tools
Allowed Action: Maintain (Action is only available from Add or Remove Programs)
Reason: Cannot maintain product, to maintain the product go to Add or Remove Programs
It has been pointed out that the following services should have been stopped prior to removal.
SQL Server Active Directory Helper
SQL Server Browser
SQL Server FullTest Search (SQLEXPRESS)
SQL Server Reporting Services (SQLEXPRESS)
Surely this should be managed by the Add/Remove process!
I was able to successfully re-install the program as long as I created a new instance.
What should be the correct process to remove SQL Server Express and if necessary how do I remove services if they do not get deleted?
TIA
Steve
I am trying to install MS SQL Express Advanced in my Laptop to be used in conjunction with ColdFusion programming environment. Abs newbe with MSSQL.
It looks like the Management Studio Express has not been installed. I have tried to install the 64bits stand alone from msdn.microsoft. but my processor does not support it.
Please please advise.
ThankYou very much
ContiW
SQL Server 2005 Setup has detected incompatible components from beta
versions of Visual Studio, .NET Framework, or SQL Server 2005.
Use Add or Remove Programs to remove these components, and the run SQL
Server 2005 Setup again.
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07
is not compatible with current builds of SQL Server.Expected at least
version: 9.00.1399.00
I used Add/Remove Progs and used the list in the order suggested to
remove all beta versions of VB, SQL, .NET and etc. Nothing is
listed. I do have VB6 PRO. I have looked for directories
and removed all. I have searched for SQLexpress in the registry
and eliminated all I could find. I reinstalled .Net 2.0 and I'm still
finding this problem.
Microsoft SQL Server 2005 Setup beginning at Thu Jun 08 17:37:43 2006
Process ID : 164
c:90b92fd6a1de42b9eesetup.exe Version: 2005.90.2047.0
Running: LoadResourcesAction at: 2006/5/8 17:37:43
Complete: LoadResourcesAction at: 2006/5/8 17:37:43, returned true
Running: ParseBootstrapOptionsAction at: 2006/5/8 17:37:43
Loaded DLL:c:90b92fd6a1de42b9eexmlrw.dll Version:2.0.3609.0
Complete: ParseBootstrapOptionsAction at: 2006/5/8 17:37:43, returned true
Running: ValidateWinNTAction at: 2006/5/8 17:37:43
Complete: ValidateWinNTAction at: 2006/5/8 17:37:43, returned true
Running: ValidateMinOSAction at: 2006/5/8 17:37:43
Complete: ValidateMinOSAction at: 2006/5/8 17:37:43, returned true
Running: PerformSCCAction at: 2006/5/8 17:37:43
Complete: PerformSCCAction at: 2006/5/8 17:37:43, returned true
Running: ActivateLoggingAction at: 2006/5/8 17:37:43
Complete: ActivateLoggingAction at: 2006/5/8 17:37:43, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__164" returned false.
Running: PerformSCCAction2 at: 2006/5/8 17:37:43
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}" versioned 9.00.1187.07
is not compatible with current builds of SQL Server.Expected at least
version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Express Edition CTP (SQLEXPRESS)"
Product "{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}" versioned 9.00.1187.07
is not compatible with current builds of SQL Server.Expected at least
version: 9.00.1399.00
The Product Name is "Microsoft SQL Server 2005 Tools Express Edition CTP"
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
SQL Server 2005 Setup has detected incompatible
components from beta versions of Visual Studio, .NET Framework, or SQL
Server 2005. Use Add or Remove Programs to remove these components, and
then run SQL Server 2005 Setup again. For detailed instructions on
uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
Class not registered.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032
Thank you for your assistance.
Hi,
We're creating an installer package for SQL Express 2005 and I'm using the built-in setup project in VS 2005 to create my MSI.
Everything appears to be working well, excpet that on Windows XP Home the SQL Express package is exiting with an error code 70002. I've googled for several days now and simply can't find any help on the 70002 exit code. Can anyone help ?
The command line arguments (I've split them onto seperate lines for clarity) we're passing to "sqlexpr32.exe" are : -
/qn
INSTANCENAME=OurInstance
SAPWD="OurPassword"
ADDLOCAL=SQL_Engine,SQL_Data_Files,Client_Components,Connectivity
SQLBROWSERAUTOSTART=1
SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"
AGTACCOUNT="NT AUTHORITYSYSTEM"
ASACCOUNT="NT AUTHORITYSYSTEM"
RSACCOUNT="NT AUTHORITYSYSTEM"
SECURITYMODE=SQL
DISABLENETWORKPROTOCOLS=0
SQLAUTOSTART=1
It is not in the add and remove programs. I did what was told and stopped all processes of SQL, I had SQL 2000 running, now I am getting: The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2, I get this when running msiexe /x {the number for the beta}
Could someone please help me, I need to have this install to take courses this weekend, Want to complete the install today, which is Friday.
After installing Visual Studio 2005 everything has installed fine EXCEPT SQLSERVER 2005. I remember having had the same problem some moths ago, but can't remember now how to fix it. I deinstalled VS2005 and installed back again, but the result was the same. SQLSERVER failed to install
thanks
I have installed SQL Server Express with Advanced Services SP1 option. I am not really sure if I should have done this but I could not resist the temptation to have as many options as I could get. I even installed some samples/sample databases.
However, I cannot understand how to start using the SQL Express package which (unlike the Visual Basic 2005 Express or the Web Developer Express I also downloaded) does not show me a start up page. I get SQL Server Configuration Manager, SQL Server Error and Usage Reporting and SQL Server Surface Area Configuration, all from Configuration Tools. I have no idea how to proceed.
Could I have downloaded the wrong package?
hello, I am having some problems installing the sql 2005 express that comes with the asp.net 2.0
It says that the installation failed thats all. Anyone with that kind of problem?
Question----------Is term "machine-name" refer to as the name that you name the pc when u first setting up a new pc from out the box?
So if my pc name is {Delldata} when i 'm installing SQLEXPRESS. ,you have a choice of default instance SQLEXPRESS., and browse for instance.do i have to name the instance delldata/SQLEXPRESS for the name instance.to work
Or leave it as SQLEXPRESS and hit next?
I just tried installing SQL Server Management Studio Express Edition (SSMSEE?) and it wouldn't install because I had the "regular" SQL Server Management Studio already installed. Is that correct? The version I installed was a CTP. Is the final version going to have the same limitations?
===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
I am working on Win2K Pro & had SQL Server 2005 Express & SQL Server Management Studio installed. The SQL Server name was MerverSQLEXPRESS. Due to some unavoidable reasons, I had to repair (& not re-install) Win2K but after doing so, I found that I am not able to connect to the database server. I uninstalled all the components related to SQL Server 2005 Express (like Management Studio, Support Files, BOL etc.) from my m/c & then restarted my m/c.
After doing so, I first re-installed SQL Server 2005 Express & other related components (I intended to install SQL Server 2005 Management Studio after installing SQL Server 2005 Express). While installing SQL Server 2005 Express, all the steps get executed successfully except for the last one which happens to be SQL Server Database Services. At this point, I get the following error:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
The problem is after I click the OK button, I am not even given the option to change the instance name! The Status message corresponding to SQL Server Database Services just says Setup failed. Refer to the Setup log for details. Finally, when I click the Next button, the next dialog finishes the Setup (showing the Finish button).
Now how do I overcome this problem? Please note that the Authentication mode I am using is Windows Authentication.
Someone please suggest me a concrete solution. It's driving me nuts! My receding hairline is getting further receded!
Lastly, please note that, as far as possible, I would like to keep the instance name as MerverSQLEXPRESS only.
Hi everyone
I have just installed SQL Server 2005, default settings. I have attempted to add a new ODBC driver using Control Panel - Administrative Tools - Data Sources (ODBC) - System DSN tab - Add - SQL Server - default settings, but it fails.
I did all this for MySQL some months ago, but I must have forgotten something.
Please can someone tell me what to do next.
Thanks in advance.
Jonathan
Hello, I'll start by saying that I don't know the first thing about SQL.
I have product that I am trying to setup on a windows 2003 R2 SP2 server that requires SQL Server Express 2005. I have this same setup installed under Windows XP Pro SP2 and it works fine.
The product uses a PHP script to talk to the SQL Server to create the orginal DB but I get the following errors:
*******************************************************************************************************************************************
Creating initial MFP Database...
Warning: mssql_pconnect() [function.mssql-pconnect]: Unable to connect to server: localhost,1444 in C:Inetpubwwwrootdbwrap.php on line 15
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: SELECT * FROM master.dbo.sysdatabases WHERE name = 'MFPACS'
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:Inetpubwwwrootdbwrap.php on line 55
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE DATABASE MFPACS
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 26
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE TABLE Logs ( username varchar(32) not null, accesstime datetime not null, message varchar(32) not null )
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE TABLE Users ( username varchar(32) not null, passmd5 char(32) not null, fullname varchar(64) not null, access int not null, interface int not null, timeout int not null, loggedin bit not null, remoteip varchar(16) null, lastaction datetime null )
*********************************************************************************************************
I have enabled the running of PHP scripts under IIS in Windows 2003 R2 (along with all of the other listed web executables). But I am stuck. For some reason the PHP scripts seem to either not have permission to talk to the DB, or Windows has some extra security in it that I need to know how to work correctly with.
I also am checking my ODBC > System DSN
when I try to craete my datasource, I get:
Connection Failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
Connection failed;
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Native Client]Login timeout expired
Connection Failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client] An error has occurred while establishing a connection to the server. When connecting to the SQL server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
FYI I have set TCP/IP properties for SQL under Protocol > General > Enable - YES.
Thanks for any assistance.