Peculiar problem with seemingly identical data

Hello,

I have this peculiar problem concerning MS SQL Server.

My company works with an mailing application (ASP) which uses SQL
Server as it's repository. What I want to do is send data directly
from my own application to this SQL Server in order to feed the
mailing application.

To test if this was possible I linked the tables from SQL Server in MS
Access and entered the data. This worked fine and the data was picked
up correctly by the mailing application.

The problem occurs when I send the data from my application (Java
application with JDBC connection). The data is in this case no longer
picked up by the application. The strange thing is that the data which
is entered through Access and the data from the Application look
identical in de database view. The problem also occurs when the data
is send with the tool winSQL and when I view the data in here it still
looks identical.

Even more strange is when I select the record which is not working in
Access and copy it into a new record (only changing the key) it
suddenly works!

Has anyone have an idea how this can be?

Thanks in advance,

Sander Janssen.Sander Janssen (sjanssen@.plex.nl) writes:
> My company works with an mailing application (ASP) which uses SQL
> Server as it's repository. What I want to do is send data directly
> from my own application to this SQL Server in order to feed the
> mailing application.
> To test if this was possible I linked the tables from SQL Server in MS
> Access and entered the data. This worked fine and the data was picked
> up correctly by the mailing application.
> The problem occurs when I send the data from my application (Java
> application with JDBC connection). The data is in this case no longer
> picked up by the application. The strange thing is that the data which
> is entered through Access and the data from the Application look
> identical in de database view. The problem also occurs when the data
> is send with the tool winSQL and when I view the data in here it still
> looks identical.
> Even more strange is when I select the record which is not working in
> Access and copy it into a new record (only changing the key) it
> suddenly works!

I don't have a clue. The thing is, I have no idea by which criterias
your application is picking up data. You need to find this out one
way or another. One way to do this is to use the Profiler to catch
which SQL it is using.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Which JDBC Driver and what version of SQL Server?

"Sander Janssen" <sjanssen@.plex.nl> wrote in message
news:e3b8d8ea.0307040443.5bc4a8d@.posting.google.co m...
> Hello,
> I have this peculiar problem concerning MS SQL Server.
> My company works with an mailing application (ASP) which uses SQL
> Server as it's repository. What I want to do is send data directly
> from my own application to this SQL Server in order to feed the
> mailing application.
> To test if this was possible I linked the tables from SQL Server in MS
> Access and entered the data. This worked fine and the data was picked
> up correctly by the mailing application.
> The problem occurs when I send the data from my application (Java
> application with JDBC connection). The data is in this case no longer
> picked up by the application. The strange thing is that the data which
> is entered through Access and the data from the Application look
> identical in de database view. The problem also occurs when the data
> is send with the tool winSQL and when I view the data in here it still
> looks identical.
> Even more strange is when I select the record which is not working in
> Access and copy it into a new record (only changing the key) it
> suddenly works!
> Has anyone have an idea how this can be?
> Thanks in advance,
> Sander Janssen.|||Hello,

I have found the source of the problem. It isn't as peculiar as I
thought at first though. The problem was that I wrote a date to an
identifier field and the characters ":" were the source of the problem
in the mailing application. When I replaced them with underscores it
all works fine!

Thanks for your help anyway!

Sander Janssen.

PDF Rendering from an ASP page

Hi Friends,
How can we render a page in pdf format directly from the Web
Aplication. With out the File Down Load screen.
Thanks
Josethis is a browser issue. You can stream the report (in any format) down to
the browser as
contenttype={what ever you got} and
response.writebinary({your array of bytes})
The browser decides to do the open vs. save dialog depending on its own
settings, I think.
dlr
"Jose Francis" <josefrancis@.gmail.com> wrote in message
news:482833ae.0409170516.1ec28fb2@.posting.google.com...
> Hi Friends,
> How can we render a page in pdf format directly from the Web
> Aplication. With out the File Down Load screen.
> Thanks
> Jose

PDF Render Problem

Hello,
Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
user can download the report onto their local drive. everything works fine
except when they open the file it gives errors ' There was an error opening
this document. The file is damaged and could not be repaired'. Please let me
know what is wrong with this code.
Thanks
_sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
_S_DEVICE_INFO = "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
_bResults = rs.Render(_sReportLocation, "PDF", Nothing,
_S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
Nothing, Nothing)
Response.Clear()
Response.ContentType = "application/pdf"
If _sMimeType <> "text/html" Then
Response.AddHeader("Content-Disposition", "attachment;
filename=" & "BarChart.pdf")
End If
Response.BinaryWrite(_bResults)
--
Raj ChandraDoes it work on some computers but not all? This may sound kind of silly,
but we have seen similar problems with Adobe before.
Try deleting all of temp internet files on the client computer and running
the report. Its worked for us in the past when the report runs fine on one
computer but not the next.
"Raj Chandra" wrote:
> Hello,
>
> Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> user can download the report onto their local drive. everything works fine
> except when they open the file it gives errors ' There was an error opening
> this document. The file is damaged and could not be repaired'. Please let me
> know what is wrong with this code.
> Thanks
> _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> _S_DEVICE_INFO => "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> Nothing, Nothing)
> Response.Clear()
> Response.ContentType = "application/pdf"
> If _sMimeType <> "text/html" Then
> Response.AddHeader("Content-Disposition", "attachment;
> filename=" & "BarChart.pdf")
> End If
> Response.BinaryWrite(_bResults)
> --
> Raj Chandra|||Hi Pinolian, thanks for the response.
I tried on a different machine it did not work and I also tried after
deleting temp files same result.
"Pinolian" wrote:
> Does it work on some computers but not all? This may sound kind of silly,
> but we have seen similar problems with Adobe before.
> Try deleting all of temp internet files on the client computer and running
> the report. Its worked for us in the past when the report runs fine on one
> computer but not the next.
>
> "Raj Chandra" wrote:
> > Hello,
> >
> >
> > Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> > user can download the report onto their local drive. everything works fine
> > except when they open the file it gives errors ' There was an error opening
> > this document. The file is damaged and could not be repaired'. Please let me
> > know what is wrong with this code.
> >
> > Thanks
> >
> > _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> > _S_DEVICE_INFO => > "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> >
> > _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> > _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > Nothing, Nothing)
> >
> > Response.Clear()
> > Response.ContentType = "application/pdf"
> >
> > If _sMimeType <> "text/html" Then
> > Response.AddHeader("Content-Disposition", "attachment;
> > filename=" & "BarChart.pdf")
> > End If
> > Response.BinaryWrite(_bResults)
> > --
> > Raj Chandra|||Have you installed Reporting Services Service Pack 1?
"Raj Chandra" wrote:
> Hi Pinolian, thanks for the response.
> I tried on a different machine it did not work and I also tried after
> deleting temp files same result.
>
> "Pinolian" wrote:
> >
> > Does it work on some computers but not all? This may sound kind of silly,
> > but we have seen similar problems with Adobe before.
> >
> > Try deleting all of temp internet files on the client computer and running
> > the report. Its worked for us in the past when the report runs fine on one
> > computer but not the next.
> >
> >
> > "Raj Chandra" wrote:
> >
> > > Hello,
> > >
> > >
> > > Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> > > user can download the report onto their local drive. everything works fine
> > > except when they open the file it gives errors ' There was an error opening
> > > this document. The file is damaged and could not be repaired'. Please let me
> > > know what is wrong with this code.
> > >
> > > Thanks
> > >
> > > _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> > > _S_DEVICE_INFO => > > "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> > >
> > > _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> > > _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > > Nothing, Nothing)
> > >
> > > Response.Clear()
> > > Response.ContentType = "application/pdf"
> > >
> > > If _sMimeType <> "text/html" Then
> > > Response.AddHeader("Content-Disposition", "attachment;
> > > filename=" & "BarChart.pdf")
> > > End If
> > > Response.BinaryWrite(_bResults)
> > > --
> > > Raj Chandra|||Yes, I have RS SP1 installed. XL file works fine I am trouble only with PDF
files.
"Kevin Weir" wrote:
> Have you installed Reporting Services Service Pack 1?
>
> "Raj Chandra" wrote:
> > Hi Pinolian, thanks for the response.
> >
> > I tried on a different machine it did not work and I also tried after
> > deleting temp files same result.
> >
> >
> > "Pinolian" wrote:
> >
> > >
> > > Does it work on some computers but not all? This may sound kind of silly,
> > > but we have seen similar problems with Adobe before.
> > >
> > > Try deleting all of temp internet files on the client computer and running
> > > the report. Its worked for us in the past when the report runs fine on one
> > > computer but not the next.
> > >
> > >
> > > "Raj Chandra" wrote:
> > >
> > > > Hello,
> > > >
> > > >
> > > > Below is the code I have written using SOAP API, VB.Net and ASP.net, so that
> > > > user can download the report onto their local drive. everything works fine
> > > > except when they open the file it gives errors ' There was an error opening
> > > > this document. The file is damaged and could not be repaired'. Please let me
> > > > know what is wrong with this code.
> > > >
> > > > Thanks
> > > >
> > > > _sReportLocation = "/BAOS Reporting/DashBoardReport/RepoDashBoard"
> > > > _S_DEVICE_INFO => > > > "<DeviceInfo><Toolbar>False</Toolbar><HTMLFragment>true</HTMLFragment></DeviceInfo>"
> > > >
> > > > _bResults = rs.Render(_sReportLocation, "PDF", Nothing,
> > > > _S_DEVICE_INFO, Nothing, Nothing, Nothing, Nothing, Nothing, Nothing,
> > > > Nothing, Nothing)
> > > >
> > > > Response.Clear()
> > > > Response.ContentType = "application/pdf"
> > > >
> > > > If _sMimeType <> "text/html" Then
> > > > Response.AddHeader("Content-Disposition", "attachment;
> > > > filename=" & "BarChart.pdf")
> > > > End If
> > > > Response.BinaryWrite(_bResults)
> > > > --
> > > > Raj Chandra

PDF Downloads & ASP

I have a web application (ASP, COM+, SQLServer2K) that uses my own VB COM
components and a Crystal Reports component (a 5mb component) that takes a CR
report that I designed (about 1mb in size), executes it, and exports it as a
PDF file to the server's hard disk ready for download by my users.
Having just come across Reporting Services, it would appear to me that I
could ditch Crystal and go with Reporting Services exclusively. However, in
my browsing I have not come across how to do this with Reporting Services
without using the Report Manager (my users are "anonymous" web users and do
not have access to the server directly) and I can't seem to find any
examples of how to recreate the process I described above.
Questions:
1) Can Reporting Services run a report, and export it as PDF to server hard
drive without user intervention (or using Report Manager)?
2) Can I expect faster processing of reports with Reporting Services
compared to Crystal on the server (my Crystal reports depends entirely on
SPs in SQLServer)?
3) Are there programming examples of using Reporting Services with VB and
ASP, particularly involving PDF export and download?
Thanks for any tips or directions.1) Yes
2) don't know
3) you need to use the web service interface to interact with RS, so you
will need to look for code with uses ASP and Web services then apply what
you learn to the RS web service interface. Most code I have seen assumes
ASP.NET since the web service integration is "trouble free"
hope this helps.
dlr
"Don Miller" <nospam@.nospam.com> wrote in message
news:%234erUYMnEHA.1564@.TK2MSFTNGP09.phx.gbl...
> I have a web application (ASP, COM+, SQLServer2K) that uses my own VB COM
> components and a Crystal Reports component (a 5mb component) that takes a
CR
> report that I designed (about 1mb in size), executes it, and exports it as
a
> PDF file to the server's hard disk ready for download by my users.
> Having just come across Reporting Services, it would appear to me that I
> could ditch Crystal and go with Reporting Services exclusively. However,
in
> my browsing I have not come across how to do this with Reporting Services
> without using the Report Manager (my users are "anonymous" web users and
do
> not have access to the server directly) and I can't seem to find any
> examples of how to recreate the process I described above.
> Questions:
> 1) Can Reporting Services run a report, and export it as PDF to server
hard
> drive without user intervention (or using Report Manager)?
> 2) Can I expect faster processing of reports with Reporting Services
> compared to Crystal on the server (my Crystal reports depends entirely on
> SPs in SQLServer)?
> 3) Are there programming examples of using Reporting Services with VB and
> ASP, particularly involving PDF export and download?
> Thanks for any tips or directions.
>

pb Order by

Under ASP, I have this statement which works:
strSQL="select * from " & Table_Name
objRS.open strSQL, objConn

But when I want to sort according to my column 'Position' (which is of number type under Access 2000) It no longer works. Any Idea?:
strSQL="select * from " & Table_Name & " Order by Position"
objRS.open strSQL, objConn

I have this error:
error '80004005'
Unspecified error

I'm connected this way:
StrConnect = "Provider=Microsoft.Jet.OLEDB.4.0;"&_
"Data Source=o:\teams\pursuit\db\productdb.mdb;" &_
"Persist Security Info=False"
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = StrConnect
objConn.Open
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.activeconnection = objConn

Help:confused:Don't search, the name'position' for my field was a key word

password for sa was changed spontaneously

Hello!

We are running MS SQLServer 7.0 with ASP on Win 2k Server.
Today suddenly the Web server couldn't connect to the DB Server
because the password for sa was wrong.
We found out that the password was changed.

Is it some kind of hacking thing or just normal password expiration?
The same thing happended several month ago.

Thanks.

SamSam Kong (ssk@.chol.net) writes:
> We are running MS SQLServer 7.0 with ASP on Win 2k Server.
> Today suddenly the Web server couldn't connect to the DB Server
> because the password for sa was wrong.
> We found out that the password was changed.
> Is it some kind of hacking thing or just normal password expiration?
> The same thing happended several month ago.

There is no password expiration in SQL7. So that means that somebody
changed the password for you.

I would recommend that you change to Windows Authentication and turn
off SQL Authentication. I would also recommand that the web server
does not log with an account that has sysadm privileges. Preferrably
it should no special rights, but access to the SQL objects it needs
to access. (And that should ideally only be stored procedures!).

Finally, if the SQL Server is exposed on the Internet, you should
stick it behind a firewall.

All these precautions increase your security and decreases the risk
for malign attacks.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
MartinTo the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
change is documented in:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> Hi, All,
> I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> seasitive, anyone knows we can configure sql 2005 user password is not
> seasitive?
> Thanks for your time,
> Martin|||Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:
> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> > Hi, All,
> >
> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> > seasitive, anyone knows we can configure sql 2005 user password is not
> > seasitive?
> >
> > Thanks for your time,
> > Martin
>|||1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
collation for the system databases (AFAIK), which was decided when you installed the SQL Server
instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
and should be performed unless you have good knowledge of the SQL Server architecture and can
determine what such a rebuild will do.
2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
install 2005, and you find an like in the SQL Server program group.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
> Hi, Tibor Karaszi,
> 1) if not in Sql 2005, do you know we can configute IIS web server is not
> case seasitive?
> 2) where to see
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can
> you tell how to go there.
> Thanks in advance,
> Martin
>
> "Tibor Karaszi" wrote:
>> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
>> behavior
>> change is documented in:
>> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "martin1" <martin1@.discussions.microsoft.com> wrote in message
>> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>> > Hi, All,
>> >
>> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
>> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
>> > seasitive, anyone knows we can configure sql 2005 user password is not
>> > seasitive?
>> >
>> > Thanks for your time,
>> > Martin
>>|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:
> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
> and should be performed unless you have good knowledge of the SQL Server architecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
> > Hi, Tibor Karaszi,
> >
> > 1) if not in Sql 2005, do you know we can configute IIS web server is not
> > case seasitive?
> > 2) where to see
> > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can
> > you tell how to go there.
> >
> > Thanks in advance,
> > Martin
> >
> >
> > "Tibor Karaszi" wrote:
> >
> >> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
> >> behavior
> >> change is documented in:
> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> >> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> >> > Hi, All,
> >> >
> >> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> >> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> >> > seasitive, anyone knows we can configure sql 2005 user password is not
> >> > seasitive?
> >> >
> >> > Thanks for your time,
> >> > Martin
> >>
> >>
>|||That only applies to 2000, logins are *always* case sensitive in 2005.
If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
the consequences to running it, etc, before attempting this.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
> Hi, Tibor Karaszi,
> yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
> for sql 2000 or sql 2005?
> Thanks
> "Tibor Karaszi" wrote:
>> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
>> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
>> instances. To change this, you need to use rebuildm.exe which will scratch all the system
>> databases,
>> and should be performed unless you have good knowledge of the SQL Server architecture and can
>> determine what such a rebuild will do.
>> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
>> install 2005, and you find an like in the SQL Server program group.
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://www.solidqualitylearning.com/
>>
>> "martin1" <martin1@.discussions.microsoft.com> wrote in message
>> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>> > Hi, Tibor Karaszi,
>> >
>> > 1) if not in Sql 2005, do you know we can configute IIS web server is not
>> > case seasitive?
>> > 2) where to see
>> > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ?
>> > can
>> > you tell how to go there.
>> >
>> > Thanks in advance,
>> > Martin
>> >
>> >
>> > "Tibor Karaszi" wrote:
>> >
>> >> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
>> >> behavior
>> >> change is documented in:
>> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
>> >>
>> >> --
>> >> Tibor Karaszi, SQL Server MVP
>> >> http://www.karaszi.com/sqlserver/default.asp
>> >> http://www.solidqualitylearning.com/
>> >>
>> >>
>> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
>> >> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>> >> > Hi, All,
>> >> >
>> >> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
>> >> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
>> >> > seasitive, anyone knows we can configure sql 2005 user password is not
>> >> > seasitive?
>> >> >
>> >> > Thanks for your time,
>> >> > Martin
>> >>
>> >>
>>|||Thank you so much!
Martin
"Tibor Karaszi" wrote:
> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
> > Hi, Tibor Karaszi,
> >
> > yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
> > for sql 2000 or sql 2005?
> >
> > Thanks
> >
> > "Tibor Karaszi" wrote:
> >
> >> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> >> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> >> instances. To change this, you need to use rebuildm.exe which will scratch all the system
> >> databases,
> >> and should be performed unless you have good knowledge of the SQL Server architecture and can
> >> determine what such a rebuild will do.
> >>
> >> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> >> install 2005, and you find an like in the SQL Server program group.
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://www.solidqualitylearning.com/
> >>
> >>
> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> >> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
> >> > Hi, Tibor Karaszi,
> >> >
> >> > 1) if not in Sql 2005, do you know we can configute IIS web server is not
> >> > case seasitive?
> >> > 2) where to see
> >> > ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ?
> >> > can
> >> > you tell how to go there.
> >> >
> >> > Thanks in advance,
> >> > Martin
> >> >
> >> >
> >> > "Tibor Karaszi" wrote:
> >> >
> >> >> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This
> >> >> behavior
> >> >> change is documented in:
> >> >> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> >> >>
> >> >> --
> >> >> Tibor Karaszi, SQL Server MVP
> >> >> http://www.karaszi.com/sqlserver/default.asp
> >> >> http://www.solidqualitylearning.com/
> >> >>
> >> >>
> >> >> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> >> >> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> >> >> > Hi, All,
> >> >> >
> >> >> > I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> >> >> > sql 2005 data, but the password is case seasitive. The sql 2000 is not case
> >> >> > seasitive, anyone knows we can configure sql 2005 user password is not
> >> >> > seasitive?
> >> >> >
> >> >> > Thanks for your time,
> >> >> > Martin
> >> >>
> >> >>
> >>
> >>
>

password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
MartinTo the best of my knowledge, you cannot change to case insensitive passwords
in 2005. This behavior
change is documented in:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-
cbee8013c995.htm
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
> Hi, All,
> I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
> sql 2005 data, but the password is case seasitive. The sql 2000 is not cas
e
> seasitive, anyone knows we can configure sql 2005 user password is not
> seasitive?
> Thanks for your time,
> Martin|||Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-
cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:

> To the best of my knowledge, you cannot change to case insensitive passwor
ds in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b54
7-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>|||1: SQL Server 2000 and earlier: Whether a password is case sensitive or not
is determined by the
collation for the system databases (AFAIK), which was decided when you insta
lled the SQL Server
instances. To change this, you need to use rebuildm.exe which will scratch a
ll the system databases,
and should be performed unless you have good knowledge of the SQL Server arc
hitecture and can
determine what such a rebuild will do.
2: This is an URL for the Books Online that comes with SQL Server 2005. It i
s installed when you
install 2005, and you find an like in the SQL Server program group.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...[vbcol=seagreen]
> Hi, Tibor Karaszi,
> 1) if not in Sql 2005, do you know we can configute IIS web server is not
> case seasitive?
> 2) where to see
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b54
7-cbee8013c995.htm ? can
> you tell how to go there.
> Thanks in advance,
> Martin
>
> "Tibor Karaszi" wrote:
>|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:

> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or no
t is determined by the
> collation for the system databases (AFAIK), which was decided when you ins
talled the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch
all the system databases,
> and should be performed unless you have good knowledge of the SQL Server a
rchitecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It
is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>|||That only applies to 2000, logins are *always* case sensitive in 2005.
If you want to try this (2000): Make sure you test this on a test server fir
st, as I'm not 100%
positive. But be aware that rebuildm does *a lot* of other things as well (i
t is pretty close to a
re-install). This is why I mentioned that you should be very familiar with w
hat rebuildm does and
the consequences to running it, etc, before attempting this.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"martin1" <martin1@.discussions.microsoft.com> wrote in message
news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...[vbcol=seagreen]
> Hi, Tibor Karaszi,
> yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
> for sql 2000 or sql 2005?
> Thanks
> "Tibor Karaszi" wrote:
>|||Thank you so much!
Martin
"Tibor Karaszi" wrote:

> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server f
irst, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well
(it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with
what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
>

password case seasitive configuration

Hi, All,
I just upgrade sql 2000 to sql 2005, and try to run asp webpage to access
sql 2005 data, but the password is case seasitive. The sql 2000 is not case
seasitive, anyone knows we can configure sql 2005 user password is not
seasitive?
Thanks for your time,
Martin
Hi, Tibor Karaszi,
1) if not in Sql 2005, do you know we can configute IIS web server is not
case seasitive?
2) where to see
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm ? can you tell how to go there.
Thanks in advance,
Martin
"Tibor Karaszi" wrote:

> To the best of my knowledge, you cannot change to case insensitive passwords in 2005. This behavior
> change is documented in:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/instsql9/html/65eaafa1-9e06-4264-b547-cbee8013c995.htm
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:6108FE0B-D229-4E56-9CC9-9483AA210FC6@.microsoft.com...
>
|||Hi, Tibor Karaszi,
yuo mean sql server case seasitive can be changed by rebuidm.exe, this is
for sql 2000 or sql 2005?
Thanks
"Tibor Karaszi" wrote:

> 1: SQL Server 2000 and earlier: Whether a password is case sensitive or not is determined by the
> collation for the system databases (AFAIK), which was decided when you installed the SQL Server
> instances. To change this, you need to use rebuildm.exe which will scratch all the system databases,
> and should be performed unless you have good knowledge of the SQL Server architecture and can
> determine what such a rebuild will do.
> 2: This is an URL for the Books Online that comes with SQL Server 2005. It is installed when you
> install 2005, and you find an like in the SQL Server program group.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:059E056C-0F3A-4DCE-AADA-9EDE468DAAE6@.microsoft.com...
>
|||Thank you so much!
Martin
"Tibor Karaszi" wrote:

> That only applies to 2000, logins are *always* case sensitive in 2005.
> If you want to try this (2000): Make sure you test this on a test server first, as I'm not 100%
> positive. But be aware that rebuildm does *a lot* of other things as well (it is pretty close to a
> re-install). This is why I mentioned that you should be very familiar with what rebuildm does and
> the consequences to running it, etc, before attempting this.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "martin1" <martin1@.discussions.microsoft.com> wrote in message
> news:BF694D38-6032-4598-9CB6-4042F7D6BFC0@.microsoft.com...
>