Can not connect to mssql with php

Using mssql_connect($server, $user, $password) results in different ways the 'php server'

connects to the sql server.

On a workstation with WinXPProf, php uses the $user and $password to login and uses the

sql server authentication. Running the same script from a W2K3 server results in an error

because in this case the 'php server' tries to connect to the sql server using windows

authentication. (I have checked this difference with wireshark)

The problem has nothing to do with the sql server settings (mixed mode) / firewalls /

php.ini- file settings or versions of ntwdblib.dll because these are the same for both

connections. The problem looks more fundamental, probably due to settings in windows or

the iis version running on the server and the workstation.

Does anyone has a clue how to force php to use sql server authentication.

Pitching Theo pitcher_32@.hotmail.com

It should be as simple as setting mssql.secure_connection = Off in your php.ini. (Informative thread) If that still doesn't do it, check the output of the phpinfo() function to make sure php is using the php.ini file that you believe it is (I've had that bite me in the butt once or twice before).
|||

Like I said both php boxes read the php.ini file and yes mssql.secure_connection = Off.

This is also confirmed by phpinfo().

It seems to be a problem for more than 4 years now checking all sort of discussions

on the net. A lot of people mention this problem but no one seems to know why one

php box tries to login to the sql server with "serverName\IUSR_serverName"

(anonymous IIS account) and the other php box with an empty string continuing with

an sql server authentication providing $user and $password from the mssql_connect()

function. Like I said it doesn't look a php problem/setting but a windows specific thing.

Anyone has a clue ? please let me know

sql

Can not connect to mssql with php

Using mssql_connect($server, $user, $password) results in different ways the 'php server'

connects to the sql server.

On a workstation with WinXPProf, php uses the $user and $password to login and uses the

sql server authentication. Running the same script from a W2K3 server results in an error

because in this case the 'php server' tries to connect to the sql server using windows

authentication. (I have checked this difference with wireshark)

The problem has nothing to do with the sql server settings (mixed mode) / firewalls /

php.ini- file settings or versions of ntwdblib.dll because these are the same for both

connections. The problem looks more fundamental, probably due to settings in windows or

the iis version running on the server and the workstation.

Does anyone has a clue how to force php to use sql server authentication.

Pitching Theo pitcher_32@.hotmail.com

It should be as simple as setting mssql.secure_connection = Off in your php.ini. (Informative thread) If that still doesn't do it, check the output of the phpinfo() function to make sure php is using the php.ini file that you believe it is (I've had that bite me in the butt once or twice before).
|||

Like I said both php boxes read the php.ini file and yes mssql.secure_connection = Off.

This is also confirmed by phpinfo().

It seems to be a problem for more than 4 years now checking all sort of discussions

on the net. A lot of people mention this problem but no one seems to know why one

php box tries to login to the sql server with "serverName\IUSR_serverName"

(anonymous IIS account) and the other php box with an empty string continuing with

an sql server authentication providing $user and $password from the mssql_connect()

function. Like I said it doesn't look a php problem/setting but a windows specific thing.

Anyone has a clue ? please let me know

Can MSSQL load a tab delimited text file?

Hi all...

I would like to know if SQL SERVER can load a tab delimited text file.

If yes, how?

A search on the web did not return me the "load data" command as mysql
or other.

Thank you all.BULK INSERT|||Oh my god...

Why you say it is a bulk insert man?? Come on...

I am a MySQL user and wants to know if i can load my data on MSSQL
without a need of a converter.|||<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> Oh my god...
> Why you say it is a bulk insert man?? Come on...
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.

I'm not sure what you don't like about his answer. Did you even bother to
look up the command he gave you?
|||Don't you have Books Online available? I expect Q. John Chen assumed you
would lookup the command:
http://msdn.microsoft.com/library/d...asp?frame=true

--
David Portas
SQL Server MVP
--

<joealey2003@.yahoo.com> wrote in message
news:1117271736.412801.299580@.f14g2000cwb.googlegr oups.com...
> Oh my god...
> Why you say it is a bulk insert man?? Come on...
> I am a MySQL user and wants to know if i can load my data on MSSQL
> without a need of a converter.|||Oh...

So Bulk Insert is the command...

Thank you all...

Can MSDE and SQL live on the same system?

Hey everyone,
We are running MSDE on a Windows 200 server and it has data in it. What I
would like to know is can we also install MSSQL 2005 on that server and have
assess to both databases. Is there anything we have to do to install it and
make sure it doesn't overwrite or delete the MSDE database?
TIA,
Claytonhi Clayton,
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that
> server and have assess to both databases. Is there anything we have
> to do to install it and make sure it doesn't overwrite or delete the
> MSDE database?
MSDE and SQL Server 2005 can coexist on the same computer... just pay
attention, at installation time, not to "upgrade" the MSDE instance to a SQL
Server 2005 one..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Yes this is possible, you just have to install it as a default or named
instance, which doesn=B4t equal the instance name of the MSDE, although
I doubt that this is possible through the installer to crash the system
that way. They are using different ports, so co-existence on the system
is possible.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--|||Just interesting, why you do not want a run both databases on sql 2005?
Andris
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that server and ha
ve
> assess to both databases. Is there anything we have to do to install it a
nd
> make sure it doesn't overwrite or delete the MSDE database?
>
> TIA,
> Clayton
>|||An old app. that one dept. has been using for years was running on MSDE.
Now they are moving to a new program that uses MSSQL 2000/2005. However,
the old data is going to stay in the MSDE database (unless that dept. wants
to pay someone to do a data export/import into MSSQL). I just wanted to
make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
and all of the old data therein.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
> Just interesting, why you do not want a run both databases on sql 2005?
> Andris
> Clayton Sutton wrote:|||I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches.
Simple backup/restore. With MSDE i think u can too, backup that db and
restore to MSSQL 2005. How i understand MSDE is some as MSSQL with some
restrictions on db size,replications etc. All who run un MSDE must run
un MSSQL. I have few msde servers who replicating with MSSQL, sometimes
i need open archive of these msde databases, i do this on MSSQL without
problems.
Sry my poor english
Andris
Clayton Sutton wrote:
> An old app. that one dept. has been using for years was running on MSDE.
> Now they are moving to a new program that uses MSSQL 2000/2005. However,
> the old data is going to stay in the MSDE database (unless that dept. want
s
> to pay someone to do a data export/import into MSSQL). I just wanted to
> make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
> and all of the old data therein.
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>
>
>|||Hey Andris,
First thing, your english is fine. Don't ever apologize for that. Truth be
told, I can't spell .
Backing up MSDE is a little tricky. Most backup software doesn't have a
connector for MSDE so backing up and restore becomes a little harder.
The command line command to back one up is:
C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =
'c:\mssql7\backup\dbname.bak'"
It took me forever to find that command, and I don't know what the command
is to restore it.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...[vbcol=seagreen]
>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple
>backup/restore. With MSDE i think u can too, backup that db and restore to
>MSSQL 2005. How i understand MSDE is some as MSSQL with some restrictions
>on db size,replications etc. All who run un MSDE must run un MSSQL. I have
>few msde servers who replicating with MSSQL, sometimes i need open archive
>of these msde databases, i do this on MSSQL without problems.
> Sry my poor english
> Andris
> Clayton Sutton wrote:|||For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server 2000
(the MSDE info), you can download a copy of Books Online (BOL) at
http://www.microsoft.com/downloads/...DisplayLang=en.
Using the example syntax you provided, it would probably be something like:
osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
DISK='c:\mssql7\backup\dbname.bak'"
Note, however, that I haven't tested that. :-)
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clayton Sutton" <none@.none.com> wrote in message
news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
> Hey Andris,
> First thing, your english is fine. Don't ever apologize for that. Truth
> be told, I can't spell .
> Backing up MSDE is a little tricky. Most backup software doesn't have a
> connector for MSDE so backing up and restore becomes a little harder.
> The command line command to back one up is:
> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =
> 'c:\mssql7\backup\dbname.bak'"
> It took me forever to find that command, and I don't know what the command
> is to restore it.
>
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>|||Hey Steve,
Would that restore the DB to MSDE only. What if you wanted to restore it
into MSSQL 2000 or 2005? That's really what we are talking about, how to
move from MSDE to MSSQL 2000/2005. Get the data out of MSDE and into MSSQL.
Clayton
"Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in messa
ge
news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
> For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
> http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server
> 2000 (the MSDE info), you can download a copy of Books Online (BOL) at
> http://www.microsoft.com/downloads/...DisplayLang=en.
> Using the example syntax you provided, it would probably be something
> like:
> osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
> DISK='c:\mssql7\backup\dbname.bak'"
> Note, however, that I haven't tested that. :-)
> --
> Sincerely,
> Steve Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Clayton Sutton" <none@.none.com> wrote in message
> news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
>|||MSDE is SQL Server. So you can both attach and restore an MSDE 2000 database
into SQL Server 2000 or
2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton" <none@.none.com> wrote in message news:8GV8g.100380$JV1.10779@.fe05.news.easynews.co
m...
> Hey Steve,
> Would that restore the DB to MSDE only. What if you wanted to restore it
into MSSQL 2000 or 2005?
> That's really what we are talking about, how to move from MSDE to MSSQL 20
00/2005. Get the data
> out of MSDE and into MSSQL.
>
> Clayton
>
> "Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in mes
sage
> news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
>

Can MSDE and SQL live on the same system?

Hey everyone,
We are running MSDE on a Windows 200 server and it has data in it. What I
would like to know is can we also install MSSQL 2005 on that server and have
assess to both databases. Is there anything we have to do to install it and
make sure it doesn't overwrite or delete the MSDE database?
TIA,
Claytonhi Clayton,
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that
> server and have assess to both databases. Is there anything we have
> to do to install it and make sure it doesn't overwrite or delete the
> MSDE database?
MSDE and SQL Server 2005 can coexist on the same computer... just pay
attention, at installation time, not to "upgrade" the MSDE instance to a SQL
Server 2005 one..
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply|||Yes this is possible, you just have to install it as a default or named
instance, which doesn=B4t equal the instance name of the MSDE, although
I doubt that this is possible through the installer to crash the system
that way. They are using different ports, so co-existence on the system
is possible.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--|||Just interesting, why you do not want a run both databases on sql 2005?
Andris
Clayton Sutton wrote:
> Hey everyone,
> We are running MSDE on a Windows 200 server and it has data in it. What I
> would like to know is can we also install MSSQL 2005 on that server and have
> assess to both databases. Is there anything we have to do to install it and
> make sure it doesn't overwrite or delete the MSDE database?
>
> TIA,
> Clayton
>|||An old app. that one dept. has been using for years was running on MSDE.
Now they are moving to a new program that uses MSSQL 2000/2005. However,
the old data is going to stay in the MSDE database (unless that dept. wants
to pay someone to do a data export/import into MSSQL). I just wanted to
make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
and all of the old data therein.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
> Just interesting, why you do not want a run both databases on sql 2005?
> Andris
> Clayton Sutton wrote:
>> Hey everyone,
>> We are running MSDE on a Windows 200 server and it has data in it. What
>> I would like to know is can we also install MSSQL 2005 on that server and
>> have assess to both databases. Is there anything we have to do to
>> install it and make sure it doesn't overwrite or delete the MSDE
>> database?
>>
>> TIA,
>> Clayton|||I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches.
Simple backup/restore. With MSDE i think u can too, backup that db and
restore to MSSQL 2005. How i understand MSDE is some as MSSQL with some
restrictions on db size,replications etc. All who run un MSDE must run
un MSSQL. I have few msde servers who replicating with MSSQL, sometimes
i need open archive of these msde databases, i do this on MSSQL without
problems.
Sry my poor english
Andris
Clayton Sutton wrote:
> An old app. that one dept. has been using for years was running on MSDE.
> Now they are moving to a new program that uses MSSQL 2000/2005. However,
> the old data is going to stay in the MSDE database (unless that dept. wants
> to pay someone to do a data export/import into MSSQL). I just wanted to
> make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE
> and all of the old data therein.
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it. What
>>I would like to know is can we also install MSSQL 2005 on that server and
>>have assess to both databases. Is there anything we have to do to
>>install it and make sure it doesn't overwrite or delete the MSDE
>>database?
>>
>>TIA,
>>Clayton
>
>|||Hey Andris,
First thing, your english is fine. Don't ever apologize for that. Truth be
told, I can't spell :).
Backing up MSDE is a little tricky. Most backup software doesn't have a
connector for MSDE so backing up and restore becomes a little harder.
The command line command to back one up is:
C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk ='c:\mssql7\backup\dbname.bak'"
It took me forever to find that command, and I don't know what the command
is to restore it.
Clayton
"Andris" <spameris@.gmail.com> wrote in message
news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple
>backup/restore. With MSDE i think u can too, backup that db and restore to
>MSSQL 2005. How i understand MSDE is some as MSSQL with some restrictions
>on db size,replications etc. All who run un MSDE must run un MSSQL. I have
>few msde servers who replicating with MSSQL, sometimes i need open archive
>of these msde databases, i do this on MSSQL without problems.
> Sry my poor english
> Andris
> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on MSDE.
>> Now they are moving to a new program that uses MSSQL 2000/2005. However,
>> the old data is going to stay in the MSDE database (unless that dept.
>> wants to pay someone to do a data export/import into MSSQL). I just
>> wanted to make sure installing MSSQL on the same system as MSDE didn't
>> wipe out MSDE and all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it. What
>>I would like to know is can we also install MSSQL 2005 on that server
>>and have assess to both databases. Is there anything we have to do to
>>install it and make sure it doesn't overwrite or delete the MSDE
>>database?
>>
>>TIA,
>>Clayton
>>|||For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server 2000
(the MSDE info), you can download a copy of Books Online (BOL) at
http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en.
Using the example syntax you provided, it would probably be something like:
osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
DISK='c:\mssql7\backup\dbname.bak'"
Note, however, that I haven't tested that. :-)
--
Sincerely,
Steve Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"Clayton Sutton" <none@.none.com> wrote in message
news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
> Hey Andris,
> First thing, your english is fine. Don't ever apologize for that. Truth
> be told, I can't spell :).
> Backing up MSDE is a little tricky. Most backup software doesn't have a
> connector for MSDE so backing up and restore becomes a little harder.
> The command line command to back one up is:
> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk => 'c:\mssql7\backup\dbname.bak'"
> It took me forever to find that command, and I don't know what the command
> is to restore it.
>
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple
>>backup/restore. With MSDE i think u can too, backup that db and restore to
>>MSSQL 2005. How i understand MSDE is some as MSSQL with some restrictions
>>on db size,replications etc. All who run un MSDE must run un MSSQL. I have
>>few msde servers who replicating with MSSQL, sometimes i need open archive
>>of these msde databases, i do this on MSSQL without problems.
>> Sry my poor english
>> Andris
>> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on MSDE.
>> Now they are moving to a new program that uses MSSQL 2000/2005.
>> However, the old data is going to stay in the MSDE database (unless that
>> dept. wants to pay someone to do a data export/import into MSSQL). I
>> just wanted to make sure installing MSSQL on the same system as MSDE
>> didn't wipe out MSDE and all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it.
>>What I would like to know is can we also install MSSQL 2005 on that
>>server and have assess to both databases. Is there anything we have to
>>do to install it and make sure it doesn't overwrite or delete the MSDE
>>database?
>>
>>TIA,
>>Clayton
>>
>|||Hey Steve,
Would that restore the DB to MSDE only. What if you wanted to restore it
into MSSQL 2000 or 2005? That's really what we are talking about, how to
move from MSDE to MSSQL 2000/2005. Get the data out of MSDE and into MSSQL.
Clayton
"Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in message
news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
> For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
> http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server
> 2000 (the MSDE info), you can download a copy of Books Online (BOL) at
> http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en.
> Using the example syntax you provided, it would probably be something
> like:
> osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM
> DISK='c:\mssql7\backup\dbname.bak'"
> Note, however, that I haven't tested that. :-)
> --
> Sincerely,
> Steve Dybing
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> "Clayton Sutton" <none@.none.com> wrote in message
> news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
>> Hey Andris,
>> First thing, your english is fine. Don't ever apologize for that. Truth
>> be told, I can't spell :).
>> Backing up MSDE is a little tricky. Most backup software doesn't have a
>> connector for MSDE so backing up and restore becomes a little harder.
>> The command line command to back one up is:
>> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =>> 'c:\mssql7\backup\dbname.bak'"
>> It took me forever to find that command, and I don't know what the
>> command is to restore it.
>>
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches.
>>Simple backup/restore. With MSDE i think u can too, backup that db and
>>restore to MSSQL 2005. How i understand MSDE is some as MSSQL with some
>>restrictions on db size,replications etc. All who run un MSDE must run un
>>MSSQL. I have few msde servers who replicating with MSSQL, sometimes i
>>need open archive of these msde databases, i do this on MSSQL without
>>problems.
>> Sry my poor english
>> Andris
>> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on
>> MSDE. Now they are moving to a new program that uses MSSQL 2000/2005.
>> However, the old data is going to stay in the MSDE database (unless
>> that dept. wants to pay someone to do a data export/import into MSSQL).
>> I just wanted to make sure installing MSSQL on the same system as MSDE
>> didn't wipe out MSDE and all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message
>> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>Hey everyone,
>>We are running MSDE on a Windows 200 server and it has data in it.
>>What I would like to know is can we also install MSSQL 2005 on that
>>server and have assess to both databases. Is there anything we have
>>to do to install it and make sure it doesn't overwrite or delete the
>>MSDE database?
>>
>>TIA,
>>Clayton
>>
>|||MSDE is SQL Server. So you can both attach and restore an MSDE 2000 database into SQL Server 2000 or
2005.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Clayton" <none@.none.com> wrote in message news:8GV8g.100380$JV1.10779@.fe05.news.easynews.com...
> Hey Steve,
> Would that restore the DB to MSDE only. What if you wanted to restore it into MSSQL 2000 or 2005?
> That's really what we are talking about, how to move from MSDE to MSSQL 2000/2005. Get the data
> out of MSDE and into MSSQL.
>
> Clayton
>
> "Steve Dybing [MSFT]" <steve.dybing@.online.microsoft.com> wrote in message
> news:uIP9O6QdGHA.1436@.TK2MSFTNGP05.phx.gbl...
>> For the RESTORE syntax, you can see the SQL Server 2005 RESTORE syntax at
>> http://msdn2.microsoft.com/en-us/library/ms186858.aspx. For SQL Server 2000 (the MSDE info), you
>> can download a copy of Books Online (BOL) at
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=a6f79cb1-a420-445f-8a4b-bd77a7da194b&DisplayLang=en.
>> Using the example syntax you provided, it would probably be something like:
>> osql -Usa -P -n -Q "RESTORE DATABASE dbname FROM DISK='c:\mssql7\backup\dbname.bak'"
>> Note, however, that I haven't tested that. :-)
>> --
>> Sincerely,
>> Steve Dybing
>> This posting is provided "AS IS" with no warranties, and confers no rights.
>> "Clayton Sutton" <none@.none.com> wrote in message
>> news:2mH8g.471159$7i1.118830@.fe06.news.easynews.com...
>> Hey Andris,
>> First thing, your english is fine. Don't ever apologize for that. Truth be told, I can't spell
>> :).
>> Backing up MSDE is a little tricky. Most backup software doesn't have a connector for MSDE so
>> backing up and restore becomes a little harder.
>> The command line command to back one up is:
>> C:\MSSQL7\Binn>osql -Usa -P -n -Q "Backup Database dbname To Disk =>> 'c:\mssql7\backup\dbname.bak'"
>> It took me forever to find that command, and I don't know what the command is to restore it.
>>
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message news:%23sZUlTNdGHA.4108@.TK2MSFTNGP03.phx.gbl...
>>I just migrated from MSSQL 7 to MSSQL 2005, whithout big headaches. Simple backup/restore. With
>>MSDE i think u can too, backup that db and restore to MSSQL 2005. How i understand MSDE is some
>>as MSSQL with some restrictions on db size,replications etc. All who run un MSDE must run un
>>MSSQL. I have few msde servers who replicating with MSSQL, sometimes i need open archive of
>>these msde databases, i do this on MSSQL without problems.
>> Sry my poor english
>> Andris
>> Clayton Sutton wrote:
>> An old app. that one dept. has been using for years was running on MSDE. Now they are moving
>> to a new program that uses MSSQL 2000/2005. However, the old data is going to stay in the MSDE
>> database (unless that dept. wants to pay someone to do a data export/import into MSSQL). I
>> just wanted to make sure installing MSSQL on the same system as MSDE didn't wipe out MSDE and
>> all of the old data therein.
>>
>> Clayton
>>
>> "Andris" <spameris@.gmail.com> wrote in message news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>>Just interesting, why you do not want a run both databases on sql 2005?
>>Andris
>>Clayton Sutton wrote:
>>>Hey everyone,
>>>
>>>We are running MSDE on a Windows 200 server and it has data in it. What I would like to know
>>>is can we also install MSSQL 2005 on that server and have assess to both databases. Is there
>>>anything we have to do to install it and make sure it doesn't overwrite or delete the MSDE
>>>database?
>>>
>>>
>>>TIA,
>>>
>>>Clayton
>>
>>
>|||From your post it sounds like you believe that MSSQL and MSDE are two
different database formats. They are not. MSDE is merely a scaled-down
version of SQL Server, and the file formats are identical.
I, personally, develop in MSDE on my development machine, and then I make
changes to the live database which is running on SQL Server. When I need a
new copy of the data, I download a backup file from the SQL Server database
and run it in my MSDE. The two formats are identical.
Thus, while installing MSSQL might create conflicts with running MSDE, the
*data itself* will remain untouched. Since your MSDE data is in SQL 7
format, there may be issues with running your data on a later version of
MSSQL, but those should be able to be resolved.
"Clayton Sutton" <none@.none.com> wrote in message
news:xIt8g.391355$4P2.48017@.fe03.news.easynews.com...
> An old app. that one dept. has been using for years was running on MSDE.
> Now they are moving to a new program that uses MSSQL 2000/2005. However,
> the old data is going to stay in the MSDE database (unless that dept.
> wants to pay someone to do a data export/import into MSSQL). I just
> wanted to make sure installing MSSQL on the same system as MSDE didn't
> wipe out MSDE and all of the old data therein.
>
> Clayton
>
> "Andris" <spameris@.gmail.com> wrote in message
> news:Ocnzq1BdGHA.1272@.TK2MSFTNGP03.phx.gbl...
>> Just interesting, why you do not want a run both databases on sql 2005?
>> Andris
>> Clayton Sutton wrote:
>> Hey everyone,
>> We are running MSDE on a Windows 200 server and it has data in it. What
>> I would like to know is can we also install MSSQL 2005 on that server
>> and have assess to both databases. Is there anything we have to do to
>> install it and make sure it doesn't overwrite or delete the MSDE
>> database?
>>
>> TIA,
>> Clayton
>

Can MS SQL Server 2005 Express Installed On Windows XP Embedded ?

Hi,
Appreciate if any friends here can do me a favour by telling me whether MS
SQL Server 2005 Express can be installed on Windows XP Embedded ?
I have run the SQL setup file and while the setup process was trying to
start the SQL database service, the Setup screen prompted "The SQL server
service failed to start." The Event Viewer has captured event ID: 17311,
Source: MSSQL$SQLExpress and the description is SQL Server is terminating
because of fatal exception c000001d. This error may be caused by an
unhandled Win32 or C++ exception, or by an access violation encountered
during exception handling. Check the SQL error log for any related stack
dumps or messages. This exception forces SQL Server to shutdown. To recover
from this error, restart the server (unless SQLAgent is configured to auto
restart).
Thank you very much for your help. Have a nice day.
Best regards,
Jeff
Hi,
its not listed in the System requirements:
http://www.microsoft.com/sql/edition...s/sysreqs.mspx
But even if you could install it (with a hack) I wouldn=B4t because this
is not offically supported.
HTH, jens Suessmeyer.
http://www.sqlserver2005.de

can i using linked Server in mssql server 64 bit version?

hi,
i always set the error when i used linked server to query data from other
server(32 bit) to my main server (64bit)
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005: ]."
do i miss something or i can using linked server in 64 bit edition?
thanks,
Suwito Kurniawan
Hi
Make sure that you have MDAC 2.8 on the 32 bit machine.
You can also run a Profiler trace to see what is being sent though.
SQL Server 64 and 32 can be linked to each other, in both directions,
without any problems.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suwito Kurniawan" <suwito@.adira.co.id> wrote in message
news:#neP7OiLFHA.2764@.tk2msftngp13.phx.gbl...
> hi,
> i always set the error when i used linked server to query data from other
> server(32 bit) to my main server (64bit)
> "Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: The stored procedure required to
complete
> this operation could not be found on the server (they were supplied with
the
> ODBC setup disk for the SQL Server driver). Please contact your system
> administrator.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
> returned 0x80004005: ]."
> do i miss something or i can using linked server in 64 bit edition?
>
> thanks,
> Suwito Kurniawan
>

can i using linked Server in mssql server 64 bit version?

hi,
i always set the error when i used linked server to query data from other
server(32 bit) to my main server (64bit)
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to comp
lete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowse
t
returned 0x80004005: ]."
do i miss something or i can using linked server in 64 bit edition?
thanks,
Suwito KurniawanHi
Make sure that you have MDAC 2.8 on the 32 bit machine.
You can also run a Profiler trace to see what is being sent though.
SQL Server 64 and 32 can be linked to each other, in both directions,
without any problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suwito Kurniawan" <suwito@.adira.co.id> wrote in message
news:#neP7OiLFHA.2764@.tk2msftngp13.phx.gbl...
> hi,
> i always set the error when i used linked server to query data from other
> server(32 bit) to my main server (64bit)
> "Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: The stored procedure required to
complete
> this operation could not be found on the server (they were supplied with
the
> ODBC setup disk for the SQL Server driver). Please contact your system
> administrator.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRow
set
> returned 0x80004005: ]."
> do i miss something or i can using linked server in 64 bit edition?
>
> thanks,
> Suwito Kurniawan
>

can i using linked Server in mssql server 64 bit version?

hi,
i always set the error when i used linked server to query data from other
server(32 bit) to my main server (64bit)
"Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'SQLOLEDB' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: The stored procedure required to complete
this operation could not be found on the server (they were supplied with the
ODBC setup disk for the SQL Server driver). Please contact your system
administrator.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
returned 0x80004005: ]."
do i miss something or i can using linked server in 64 bit edition?
thanks,
Suwito KurniawanHi
Make sure that you have MDAC 2.8 on the 32 bit machine.
You can also run a Profiler trace to see what is being sent though.
SQL Server 64 and 32 can be linked to each other, in both directions,
without any problems.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Suwito Kurniawan" <suwito@.adira.co.id> wrote in message
news:#neP7OiLFHA.2764@.tk2msftngp13.phx.gbl...
> hi,
> i always set the error when i used linked server to query data from other
> server(32 bit) to my main server (64bit)
> "Server: Msg 7399, Level 16, State 1, Line 1
> OLE DB provider 'SQLOLEDB' reported an error.
> [OLE/DB provider returned message: Unspecified error]
> [OLE/DB provider returned message: The stored procedure required to
complete
> this operation could not be found on the server (they were supplied with
the
> ODBC setup disk for the SQL Server driver). Please contact your system
> administrator.]
> OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBSchemaRowset::GetRowset
> returned 0x80004005: ]."
> do i miss something or i can using linked server in 64 bit edition?
>
> thanks,
> Suwito Kurniawan
>

Can i use sql reporting svc with asp3.0 classic

Hi ,
I have to develop an application developed in asp 3.0 and now was wondering
if i could use MSSQL reproting services instead of using Crystal Reports.?
i know for design u need to have .net framework but can i integrate it while
using asp 3.0 and IIS 5.0
Thanks.
--KingIf you can figure out what the URL would be for a report, you can put
the report in an iframe, or even it's own page (i.e. a new window). Try
looking through the Reporting Services documentation for "URL Access."
Once you get the format of the URL down, it's pretty easy to customize
how the page loads. I do this to redirect users directly to PDFs of
reports.
~Andy
king wrote:
> Hi ,
> I have to develop an application developed in asp 3.0 and now was wondering
> if i could use MSSQL reproting services instead of using Crystal Reports.?
> i know for design u need to have .net framework but can i integrate it while
> using asp 3.0 and IIS 5.0
> Thanks.
> --King|||Thanks Andy.
That was helpful. Another question i have is if want the reports be
generated whenever the user clicks on the link ( i mean i wanna see latest
report everytime is it possible to do.
Also how can i implement security so that only authorized people can see
those reports . I am thinking of providing a login page and based on login
and password a person is able to see a particular report. so on the asp side
i can do it by authenticating the user against a table in database but what
about rs side .
If a person knows the url of the report can he see the report without login
?
THanks
"Andy Hardin" wrote:
> If you can figure out what the URL would be for a report, you can put
> the report in an iframe, or even it's own page (i.e. a new window). Try
> looking through the Reporting Services documentation for "URL Access."
> Once you get the format of the URL down, it's pretty easy to customize
> how the page loads. I do this to redirect users directly to PDFs of
> reports.
> ~Andy
> king wrote:
> > Hi ,
> > I have to develop an application developed in asp 3.0 and now was wondering
> > if i could use MSSQL reproting services instead of using Crystal Reports.?
> > i know for design u need to have .net framework but can i integrate it while
> > using asp 3.0 and IIS 5.0
> >
> > Thanks.
> >
> > --King
>|||The report should be freshly generated everytime someone accesses it.
I'm still trying to wrap my head around the security stuff. Every where
I've used RS has been in a domain environment where everyone has access
to all of the reports. You may want to search on google and the
newsgroup for information about implementing your own security.
~Andy
king wrote:
> Thanks Andy.
> That was helpful. Another question i have is if want the reports be
> generated whenever the user clicks on the link ( i mean i wanna see latest
> report everytime is it possible to do.
> Also how can i implement security so that only authorized people can see
> those reports . I am thinking of providing a login page and based on login
> and password a person is able to see a particular report. so on the asp side
> i can do it by authenticating the user against a table in database but what
> about rs side .
> If a person knows the url of the report can he see the report without login
> ?
> THanks
>
> "Andy Hardin" wrote:
>
>>If you can figure out what the URL would be for a report, you can put
>>the report in an iframe, or even it's own page (i.e. a new window). Try
>>looking through the Reporting Services documentation for "URL Access."
>>Once you get the format of the URL down, it's pretty easy to customize
>>how the page loads. I do this to redirect users directly to PDFs of
>>reports.
>>~Andy
>>king wrote:
>>Hi ,
>>I have to develop an application developed in asp 3.0 and now was wondering
>>if i could use MSSQL reproting services instead of using Crystal Reports.?
>>i know for design u need to have .net framework but can i integrate it while
>>using asp 3.0 and IIS 5.0
>>Thanks.
>>--King|||You may want to look at these articles on security in Reporting Services.
http://www.devx.com/dotnet/Article/26759/0/page/1
http://www.devx.com/dotnet/Article/27133/0
~Andy
king wrote:
> Thanks Andy.
> That was helpful. Another question i have is if want the reports be
> generated whenever the user clicks on the link ( i mean i wanna see latest
> report everytime is it possible to do.
> Also how can i implement security so that only authorized people can see
> those reports . I am thinking of providing a login page and based on login
> and password a person is able to see a particular report. so on the asp side
> i can do it by authenticating the user against a table in database but what
> about rs side .
> If a person knows the url of the report can he see the report without login
> ?
> THanks
>
> "Andy Hardin" wrote:
>
>>If you can figure out what the URL would be for a report, you can put
>>the report in an iframe, or even it's own page (i.e. a new window). Try
>>looking through the Reporting Services documentation for "URL Access."
>>Once you get the format of the URL down, it's pretty easy to customize
>>how the page loads. I do this to redirect users directly to PDFs of
>>reports.
>>~Andy
>>king wrote:
>>Hi ,
>>I have to develop an application developed in asp 3.0 and now was wondering
>>if i could use MSSQL reproting services instead of using Crystal Reports.?
>>i know for design u need to have .net framework but can i integrate it while
>>using asp 3.0 and IIS 5.0
>>Thanks.
>>--King

Can I use Enterprise Manager to manage MSSQL 2005 express?

Can I use the regular Enterprise Manager to manage MSSQL 2005 express or do
I have to use the Express Manager?
SQL Server 2000 Enterprise Manager does not have support for new SQL Server
2005 features. Express Manager is being replaced with a new Express version
of the SQL Server Management Studio tool introduced in SQL Server 2005. You
can get a Customer Technical Preview version of Management Studio Express
from here:
http://www.microsoft.com/downloads/d...displaylang=en
Alan Brewer [MSFT]
Content Architect, SQL Server Documentation Team
SQL Server Developer Center: http://msdn.microsoft.com/sql
SQL Server TechCenter: http://technet.microsoft.com/sql/
This posting is provided "AS IS" with no warranties, and confers no rights.

Can I specify a user in triggers?

Hi there,
I have 2 systems. SystemA has database dbA, systemB has database dbB1
to database dbBn. All these databases are MSSQL databases. The dbB1 to
dbBn will update dbA via triggers residing in these dbBs. Looks like
that I have to add the dbB users to dbA in order for the triggers in
dbB to communicate with dbA. However, it tends to have too many users
(there are many dbBs) in dbA if I have to work in this way and it's
not acceptable.
Now I am trying to set a generic user, say common_webuser, for both
dbA and dbBs. the user will login dbBi with a dbBi specific user, then
in the trigger, I want to change to common_webuser before the
statement to update dbA, finally reset the user to the dbBi specific
user. Actually I am trying to trick the trigger that the current user
is common_webuser so that I can do update to dbA. The setuser command
does not work for this purpose. Can anyone give me some suggestions on
how to acheive this? It's very urgent. Your help is highly
appreciated.
Thanks
GaryGary,
do this:
set up a common-named role in all the dbs. Give the role in dbA the access
it needs. Put the users into the role in the respective dbBs, and give the
role the permissions it needs in the respective dbBs. It then should work.
hth
Quentin
"Gary Wang" <garyw@.nomatterware.com> wrote in message
news:b2328f5c.0308061208.6813d12c@.posting.google.com...
> Hi there,
> I have 2 systems. SystemA has database dbA, systemB has database dbB1
> to database dbBn. All these databases are MSSQL databases. The dbB1 to
> dbBn will update dbA via triggers residing in these dbBs. Looks like
> that I have to add the dbB users to dbA in order for the triggers in
> dbB to communicate with dbA. However, it tends to have too many users
> (there are many dbBs) in dbA if I have to work in this way and it's
> not acceptable.
> Now I am trying to set a generic user, say common_webuser, for both
> dbA and dbBs. the user will login dbBi with a dbBi specific user, then
> in the trigger, I want to change to common_webuser before the
> statement to update dbA, finally reset the user to the dbBi specific
> user. Actually I am trying to trick the trigger that the current user
> is common_webuser so that I can do update to dbA. The setuser command
> does not work for this purpose. Can anyone give me some suggestions on
> how to acheive this? It's very urgent. Your help is highly
> appreciated.
> Thanks
> Gary|||Sorry lost the part that your dbA is on a different server than the dbBs.
In this situation, you may want to try this: each user in the dbBs are
assigned to a common remote login in the linked server, and that remote
login has the desired access for the actions needing to be performed.
hth
Quentin
"Quentin Ran" <ab@.who.com> wrote in message
news:#NFwaCGXDHA.1004@.TK2MSFTNGP12.phx.gbl...
> Gary,
> do this:
> set up a common-named role in all the dbs. Give the role in dbA the
access
> it needs. Put the users into the role in the respective dbBs, and give
the
> role the permissions it needs in the respective dbBs. It then should
work.
> hth
> Quentin
>
> "Gary Wang" <garyw@.nomatterware.com> wrote in message
> news:b2328f5c.0308061208.6813d12c@.posting.google.com...
> > Hi there,
> > I have 2 systems. SystemA has database dbA, systemB has database dbB1
> > to database dbBn. All these databases are MSSQL databases. The dbB1 to
> > dbBn will update dbA via triggers residing in these dbBs. Looks like
> > that I have to add the dbB users to dbA in order for the triggers in
> > dbB to communicate with dbA. However, it tends to have too many users
> > (there are many dbBs) in dbA if I have to work in this way and it's
> > not acceptable.
> >
> > Now I am trying to set a generic user, say common_webuser, for both
> > dbA and dbBs. the user will login dbBi with a dbBi specific user, then
> > in the trigger, I want to change to common_webuser before the
> > statement to update dbA, finally reset the user to the dbBi specific
> > user. Actually I am trying to trick the trigger that the current user
> > is common_webuser so that I can do update to dbA. The setuser command
> > does not work for this purpose. Can anyone give me some suggestions on
> > how to acheive this? It's very urgent. Your help is highly
> > appreciated.
> >
> > Thanks
> > Gary
>