Hooking old apps to SQL 2005

We would like to have our old apps talk with SQL 2005. What do I have to do
to make that happen. I have installed the SQL 2005 native client, and
defined an alias to the SQL Server. I still get connection errors so
obviously I have not done enough to set this up, or it can't be done .
Can someone direct me to some documentation or explain how to do this?
Thanks.
BarryNevermind, got it working
"barryfz" <barry@.noemail.noemail> wrote in message
news:u5NWWks7FHA.4076@.tk2msftngp13.phx.gbl...
> We would like to have our old apps talk with SQL 2005. What do I have to
> do to make that happen. I have installed the SQL 2005 native client, and
> defined an alias to the SQL Server. I still get connection errors so
> obviously I have not done enough to set this up, or it can't be done .
> Can someone direct me to some documentation or explain how to do this?
> Thanks.
> --
> Barry
>|||Would you be willing to post the results so we can see how you did it?
--
burt_king@.yahoo.com
"barryfz" wrote:

> Nevermind, got it working
>
> "barryfz" <barry@.noemail.noemail> wrote in message
> news:u5NWWks7FHA.4076@.tk2msftngp13.phx.gbl...
>
>

hooking into sql server file I/O -- file level encryption

There are a number of third party packages that do "whole file"
encryption of SQL databases. For example:
Encryptionizer (http://www.netlib.com/)
XP_CRYPT (http://www.xpcrypt.com/)
We are considering using one of these products, but I am wondering if
it is possible to "roll our own". We have some experience doing this
with sqlite; because sqlite is open source, it is relatively easy to
hook into the "pager" and perform custom encryption/decryption.
What I'd like to know is whether something similar is possible with
SQL Server (or more specifically MSDE). Or rather, clearly it is
_possible_, since the above products do it. But how? How do these
products insert themselves between the database engine and the
physical file I/O?
I speculate that they are re-implementing some file IO interfaces used
by SQL, but I don't know where to start looking for what those
interfaces might be or where they live in the registry. Or maybe I am
off base and there are some hooks provided by SQL I don't know about.
I have scoured MSDN and Google but it appears to be a difficult topic
to query.
Does anyone have any idea how this works?
TIA,
Rol(rolandp66@.yahoo.com) writes:
> There are a number of third party packages that do "whole file"
> encryption of SQL databases. For example:
> Encryptionizer (http://www.netlib.com/)
> XP_CRYPT (http://www.xpcrypt.com/)
> We are considering using one of these products, but I am wondering if
> it is possible to "roll our own". We have some experience doing this
> with sqlite; because sqlite is open source, it is relatively easy to
> hook into the "pager" and perform custom encryption/decryption.
> What I'd like to know is whether something similar is possible with
> SQL Server (or more specifically MSDE). Or rather, clearly it is
> _possible_, since the above products do it. But how? How do these
> products insert themselves between the database engine and the
> physical file I/O?
> I speculate that they are re-implementing some file IO interfaces used
> by SQL, but I don't know where to start looking for what those
> interfaces might be or where they live in the registry. Or maybe I am
> off base and there are some hooks provided by SQL I don't know about.
> I have scoured MSDN and Google but it appears to be a difficult topic
> to query.
The way to do it would indeed be to intercept the file I/O system calls.
Since SQL Server uses the interfaces in NTFS, the tool would have to
be configured to only encrypt selected files, since else you would be
encrypting - and deenscrypting - the entire disk.
Whether this actually is doable I don't know. You would have to ask in
a Windows newsgroup to get some tips on that. But I would assume that
whatever you do, it would be entirely unsupported.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||I may be missing something basic here but wouldn't it be a lot easier to
just use NTFS encryption to encrypt the files? One checkbox in the file
attributes seems a lot easier than writing your own disk driver.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
<rolandp66@.yahoo.com> wrote in message
news:1175719135.450235.272090@.b75g2000hsg.googlegroups.com...
> There are a number of third party packages that do "whole file"
> encryption of SQL databases. For example:
> Encryptionizer (http://www.netlib.com/)
> XP_CRYPT (http://www.xpcrypt.com/)
> We are considering using one of these products, but I am wondering if
> it is possible to "roll our own". We have some experience doing this
> with sqlite; because sqlite is open source, it is relatively easy to
> hook into the "pager" and perform custom encryption/decryption.
> What I'd like to know is whether something similar is possible with
> SQL Server (or more specifically MSDE). Or rather, clearly it is
> _possible_, since the above products do it. But how? How do these
> products insert themselves between the database engine and the
> physical file I/O?
> I speculate that they are re-implementing some file IO interfaces used
> by SQL, but I don't know where to start looking for what those
> interfaces might be or where they live in the registry. Or maybe I am
> off base and there are some hooks provided by SQL I don't know about.
> I have scoured MSDN and Google but it appears to be a difficult topic
> to query.
> Does anyone have any idea how this works?
> TIA,
> Rol
>|||Roger Wolter[MSFT] (rwolter@.online.microsoft.com) writes:
> I may be missing something basic here but wouldn't it be a lot easier to
> just use NTFS encryption to encrypt the files? One checkbox in the file
> attributes seems a lot easier than writing your own disk driver.
Just for fun, I stopped my SQL 2000 instance and then encrypted the
Northwind database from Explorer. When I started SQL Server, I found that
I was not able to access Northwind. This was what the SQL Server had to
tell me:
2007-04-07 11:10:32.17 spid9 Device activation error. The physical file
name 'E:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf' may be
incorrect.
2007-04-07 11:10:32.31 spid9 udopen: Operating system error 5(error not
found) during the creation/opening of physical device E:\Program Files\Micro
soft SQL Server\MSSQL\data\northwnd.ldf.
2007-04-07 11:10:32.31 spid9 FCB::Open failed: Could not open device E:\
Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf for virtual devic
e number (VDN) 2.
Now, I know zero about NTFS encryption, so there may be a simple solution,
but I figured that I should make this note, in case someone would get the
idea to try this for real.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||The key is associated with the user who does the encrypting so if you're not
encrypting while logged in as the domain user that sqlservr.exe executes as,
SQL won't be able to read the file.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Erland Sommarskog" <esquel@.sommarskog.se> wrote in message
news:Xns990B72C517060Yazorman@.127.0.0.1...
> Roger Wolter[MSFT] (rwolter@.online.microsoft.com) writes:
> Just for fun, I stopped my SQL 2000 instance and then encrypted the
> Northwind database from Explorer. When I started SQL Server, I found that
> I was not able to access Northwind. This was what the SQL Server had to
> tell me:
> 2007-04-07 11:10:32.17 spid9 Device activation error. The physical
> file name 'E:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.mdf'
> may be incorrect.
> 2007-04-07 11:10:32.31 spid9 udopen: Operating system error 5(error
> not found) during the creation/opening of physical device E:\Program
> Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf.
> 2007-04-07 11:10:32.31 spid9 FCB::Open failed: Could not open device
> E:\Program Files\Microsoft SQL Server\MSSQL\data\northwnd.ldf for virtual
> device number (VDN) 2.
>
> Now, I know zero about NTFS encryption, so there may be a simple solution,
> but I figured that I should make this note, in case someone would get the
> idea to try this for real.
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/pr...oads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodin...ions/books.mspx|||Roger Wolter[MSFT] (rwolter@.online.microsoft.com) writes:
> The key is associated with the user who does the encrypting so if you're
> not encrypting while logged in as the domain user that sqlservr.exe
> executes as, SQL won't be able to read the file.
I suspected it was something like that, but I didn't feel like testing it.
Thanks for straighten it out, Roger.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspxsql

Hong kong fonts

I am using sql server 2000 english
Once i insert chinese font, it is ok
But when I insert one hong kong font, then it make whole chinese font
crack...
But when i copy whole message and update(not insert), then the text can be
shown
is it microsoft bug?Izumi,
It is difficult to know, because you have not provided much information.
If you are inserting Simplified Chinese characters in GB encoding and
Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
code page support only for GB and not Big-5.
If you can use Unicode in all cases, it should be possible to handle
both character sets.
Please tell us the data type of the column (probably varchar, nvarchar,
text, or ntext) how you are inserting data. INSERT query, or data file
import, or typing in Enterprise Manager or some tool? Also, how do you
do the update? If you specify character strings in a query, do you use
N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
It could also be a bug, and the additional information will help.
SK
izumi wrote:
>I am using sql server 2000 english
>Once i insert chinese font, it is ok
>But when I insert one hong kong font, then it make whole chinese font
>crack...
>But when i copy whole message and update(not insert), then the text can be
>shown
>is it microsoft bug?
>
>|||Good, I find the good person to solve the problem
u really understand my story
ok
let me explain
ASP page to insert and update the character to sql server
It is not GB
It is Big5 actually
but there are around 5000 Hong Kong words which is not Big5
so we need some additional hong kong character set to recongize some hong
kong words
http://www.microsoft.com/hk/hkscs/default.asp
you can see the details
The word I cannot insert is one out of 5000
sure I use N'...in asp page
And i use nvarchar for data type
it is unicode
that what I said it was running well before
but for special hong kong character
when insert, the words is crack
when update hong kong character, it is running well, no crack
"Steve Kass" <skass@.drew.edu> wrote in message
news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> Izumi,
> It is difficult to know, because you have not provided much information.
> If you are inserting Simplified Chinese characters in GB encoding and
> Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
> code page support only for GB and not Big-5.
> If you can use Unicode in all cases, it should be possible to handle
> both character sets.
> Please tell us the data type of the column (probably varchar, nvarchar,
> text, or ntext) how you are inserting data. INSERT query, or data file
> import, or typing in Enterprise Manager or some tool? Also, how do you
> do the update? If you specify character strings in a query, do you use
> N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> It could also be a bug, and the additional information will help.
> SK
> izumi wrote:
> >I am using sql server 2000 english
> >
> >Once i insert chinese font, it is ok
> >
> >But when I insert one hong kong font, then it make whole chinese font
> >crack...
> >
> >But when i copy whole message and update(not insert), then the text can
be
> >shown
> >
> >is it microsoft bug?
> >
> >
> >
> >
>|||Izumi,
Do you update from the asp page also? If insert and update are both
from asp page, but insert does not work, I'm not sure what the problem is.
What codepage does your asp page expect for input? Supplementary Hong
Kong character set is a new code page, 951.
SK
izumi wrote:
>Good, I find the good person to solve the problem
>u really understand my story
>ok
>let me explain
>ASP page to insert and update the character to sql server
>It is not GB
>It is Big5 actually
>but there are around 5000 Hong Kong words which is not Big5
>so we need some additional hong kong character set to recongize some hong
>kong words
>http://www.microsoft.com/hk/hkscs/default.asp
>you can see the details
>The word I cannot insert is one out of 5000
>sure I use N'...in asp page
>And i use nvarchar for data type
>it is unicode
>that what I said it was running well before
>but for special hong kong character
>when insert, the words is crack
>when update hong kong character, it is running well, no crack
>
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
>
>>Izumi,
>>It is difficult to know, because you have not provided much information.
>>If you are inserting Simplified Chinese characters in GB encoding and
>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
>>code page support only for GB and not Big-5.
>>If you can use Unicode in all cases, it should be possible to handle
>>both character sets.
>>Please tell us the data type of the column (probably varchar, nvarchar,
>>text, or ntext) how you are inserting data. INSERT query, or data file
>>import, or typing in Enterprise Manager or some tool? Also, how do you
>>do the update? If you specify character strings in a query, do you use
>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
>>It could also be a bug, and the additional information will help.
>>SK
>>izumi wrote:
>>
>>I am using sql server 2000 english
>>Once i insert chinese font, it is ok
>>But when I insert one hong kong font, then it make whole chinese font
>>crack...
>>But when i copy whole message and update(not insert), then the text can
>>
>be
>
>>shown
>>is it microsoft bug?
>>
>>
>>
>
>|||good point
i am using 950
let me try 951
sure both method is doing on Asp
"Steve Kass" <skass@.drew.edu> wrote in message
news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> Izumi,
> Do you update from the asp page also? If insert and update are both
> from asp page, but insert does not work, I'm not sure what the problem
is.
> What codepage does your asp page expect for input? Supplementary Hong
> Kong character set is a new code page, 951.
> SK
>
> izumi wrote:
> >Good, I find the good person to solve the problem
> >u really understand my story
> >
> >ok
> >let me explain
> >ASP page to insert and update the character to sql server
> >It is not GB
> >It is Big5 actually
> >but there are around 5000 Hong Kong words which is not Big5
> >so we need some additional hong kong character set to recongize some hong
> >kong words
> >http://www.microsoft.com/hk/hkscs/default.asp
> >you can see the details
> >The word I cannot insert is one out of 5000
> >sure I use N'...in asp page
> >And i use nvarchar for data type
> >it is unicode
> >that what I said it was running well before
> >but for special hong kong character
> >when insert, the words is crack
> >when update hong kong character, it is running well, no crack
> >
> >
> >"Steve Kass" <skass@.drew.edu> wrote in message
> >news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >
> >
> >>Izumi,
> >>
> >>It is difficult to know, because you have not provided much information.
> >>If you are inserting Simplified Chinese characters in GB encoding and
> >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
> >>code page support only for GB and not Big-5.
> >>
> >>If you can use Unicode in all cases, it should be possible to handle
> >>both character sets.
> >>
> >>Please tell us the data type of the column (probably varchar, nvarchar,
> >>text, or ntext) how you are inserting data. INSERT query, or data file
> >>import, or typing in Enterprise Manager or some tool? Also, how do you
> >>do the update? If you specify character strings in a query, do you use
> >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>
> >>It could also be a bug, and the additional information will help.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>I am using sql server 2000 english
> >>
> >>Once i insert chinese font, it is ok
> >>
> >>But when I insert one hong kong font, then it make whole chinese font
> >>crack...
> >>
> >>But when i copy whole message and update(not insert), then the text can
> >>
> >>
> >be
> >
> >
> >>shown
> >>
> >>is it microsoft bug?
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>|||when i change to <%
Session.CodePage=9511
Response.Charset="big5"
%>
but it show error on asp
rror Type:
SessionID, ASP 0204 (0x80004005)
An invalid CodePage value was specified.
"izumi" <test@.test.com> wrote in message
news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> good point
> i am using 950
> let me try 951
> sure both method is doing on Asp
> "Steve Kass" <skass@.drew.edu> wrote in message
> news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> > Izumi,
> >
> > Do you update from the asp page also? If insert and update are both
> > from asp page, but insert does not work, I'm not sure what the problem
> is.
> > What codepage does your asp page expect for input? Supplementary Hong
> > Kong character set is a new code page, 951.
> >
> > SK
> >
> >
> > izumi wrote:
> >
> > >Good, I find the good person to solve the problem
> > >u really understand my story
> > >
> > >ok
> > >let me explain
> > >ASP page to insert and update the character to sql server
> > >It is not GB
> > >It is Big5 actually
> > >but there are around 5000 Hong Kong words which is not Big5
> > >so we need some additional hong kong character set to recongize some
hong
> > >kong words
> > >http://www.microsoft.com/hk/hkscs/default.asp
> > >you can see the details
> > >The word I cannot insert is one out of 5000
> > >sure I use N'...in asp page
> > >And i use nvarchar for data type
> > >it is unicode
> > >that what I said it was running well before
> > >but for special hong kong character
> > >when insert, the words is crack
> > >when update hong kong character, it is running well, no crack
> > >
> > >
> > >"Steve Kass" <skass@.drew.edu> wrote in message
> > >news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> > >
> > >
> > >>Izumi,
> > >>
> > >>It is difficult to know, because you have not provided much
information.
> > >>If you are inserting Simplified Chinese characters in GB encoding and
> > >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
> > >>code page support only for GB and not Big-5.
> > >>
> > >>If you can use Unicode in all cases, it should be possible to handle
> > >>both character sets.
> > >>
> > >>Please tell us the data type of the column (probably varchar,
nvarchar,
> > >>text, or ntext) how you are inserting data. INSERT query, or data file
> > >>import, or typing in Enterprise Manager or some tool? Also, how do you
> > >>do the update? If you specify character strings in a query, do you use
> > >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> > >>
> > >>It could also be a bug, and the additional information will help.
> > >>
> > >>SK
> > >>
> > >>izumi wrote:
> > >>
> > >>
> > >>
> > >>I am using sql server 2000 english
> > >>
> > >>Once i insert chinese font, it is ok
> > >>
> > >>But when I insert one hong kong font, then it make whole chinese font
> > >>crack...
> > >>
> > >>But when i copy whole message and update(not insert), then the text
can
> > >>
> > >>
> > >be
> > >
> > >
> > >>shown
> > >>
> > >>is it microsoft bug?
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >
> > >
> > >
> > >
> >
>|||Did you type 951 or 9511? I don't have any other good ideas, but I will
mention this question to Microsoft and see what they say.
SK
izumi wrote:
>when i change to <%
>Session.CodePage=9511
>Response.Charset="big5"
>%>
>but it show error on asp
>rror Type:
>SessionID, ASP 0204 (0x80004005)
>An invalid CodePage value was specified.
>"izumi" <test@.test.com> wrote in message
>news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
>
>>good point
>>i am using 950
>>let me try 951
>>sure both method is doing on Asp
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
>>
>>Izumi,
>>Do you update from the asp page also? If insert and update are both
>>from asp page, but insert does not work, I'm not sure what the problem
>>
>>is.
>>
>>What codepage does your asp page expect for input? Supplementary Hong
>>Kong character set is a new code page, 951.
>>SK
>>
>>izumi wrote:
>>
>>Good, I find the good person to solve the problem
>>u really understand my story
>>ok
>>let me explain
>>ASP page to insert and update the character to sql server
>>It is not GB
>>It is Big5 actually
>>but there are around 5000 Hong Kong words which is not Big5
>>so we need some additional hong kong character set to recongize some
>>
>hong
>
>>kong words
>>http://www.microsoft.com/hk/hkscs/default.asp
>>you can see the details
>>The word I cannot insert is one out of 5000
>>sure I use N'...in asp page
>>And i use nvarchar for data type
>>it is unicode
>>that what I said it was running well before
>>but for special hong kong character
>>when insert, the words is crack
>>when update hong kong character, it is running well, no crack
>>
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
>>
>>
>>Izumi,
>>It is difficult to know, because you have not provided much
>>
>information.
>
>>If you are inserting Simplified Chinese characters in GB encoding and
>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you have
>>code page support only for GB and not Big-5.
>>If you can use Unicode in all cases, it should be possible to handle
>>both character sets.
>>Please tell us the data type of the column (probably varchar,
>>
>nvarchar,
>
>>text, or ntext) how you are inserting data. INSERT query, or data file
>>import, or typing in Enterprise Manager or some tool? Also, how do you
>>do the update? If you specify character strings in a query, do you use
>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
>>It could also be a bug, and the additional information will help.
>>SK
>>izumi wrote:
>>
>>
>>I am using sql server 2000 english
>>Once i insert chinese font, it is ok
>>But when I insert one hong kong font, then it make whole chinese font
>>crack...
>>But when i copy whole message and update(not insert), then the text
>>
>can
>
>>
>>be
>>
>>
>>shown
>>is it microsoft bug?
>>
>>
>>
>>
>>
>>
>>
>
>|||sorry I change to 951
ASP Error
"Steve Kass" <skass@.drew.edu> wrote in message
news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
> Did you type 951 or 9511? I don't have any other good ideas, but I will
> mention this question to Microsoft and see what they say.
> SK
> izumi wrote:
> >when i change to <%
> >Session.CodePage=9511
> >Response.Charset="big5"
> >%>
> >but it show error on asp
> >rror Type:
> >SessionID, ASP 0204 (0x80004005)
> >An invalid CodePage value was specified.
> >"izumi" <test@.test.com> wrote in message
> >news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> >
> >
> >>good point
> >>i am using 950
> >>let me try 951
> >>
> >>sure both method is doing on Asp
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> >>
> >>
> >>Izumi,
> >>
> >>Do you update from the asp page also? If insert and update are both
> >>from asp page, but insert does not work, I'm not sure what the problem
> >>
> >>
> >>is.
> >>
> >>
> >>What codepage does your asp page expect for input? Supplementary Hong
> >>Kong character set is a new code page, 951.
> >>
> >>SK
> >>
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>Good, I find the good person to solve the problem
> >>u really understand my story
> >>
> >>ok
> >>let me explain
> >>ASP page to insert and update the character to sql server
> >>It is not GB
> >>It is Big5 actually
> >>but there are around 5000 Hong Kong words which is not Big5
> >>so we need some additional hong kong character set to recongize some
> >>
> >>
> >hong
> >
> >
> >>kong words
> >>http://www.microsoft.com/hk/hkscs/default.asp
> >>you can see the details
> >>The word I cannot insert is one out of 5000
> >>sure I use N'...in asp page
> >>And i use nvarchar for data type
> >>it is unicode
> >>that what I said it was running well before
> >>but for special hong kong character
> >>when insert, the words is crack
> >>when update hong kong character, it is running well, no crack
> >>
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >>
> >>
> >>
> >>
> >>Izumi,
> >>
> >>It is difficult to know, because you have not provided much
> >>
> >>
> >information.
> >
> >
> >>If you are inserting Simplified Chinese characters in GB encoding and
> >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
have
> >>code page support only for GB and not Big-5.
> >>
> >>If you can use Unicode in all cases, it should be possible to handle
> >>both character sets.
> >>
> >>Please tell us the data type of the column (probably varchar,
> >>
> >>
> >nvarchar,
> >
> >
> >>text, or ntext) how you are inserting data. INSERT query, or data
file
> >>import, or typing in Enterprise Manager or some tool? Also, how do
you
> >>do the update? If you specify character strings in a query, do you
use
> >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>
> >>It could also be a bug, and the additional information will help.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>
> >>
> >>I am using sql server 2000 english
> >>
> >>Once i insert chinese font, it is ok
> >>
> >>But when I insert one hong kong font, then it make whole chinese
font
> >>crack...
> >>
> >>But when i copy whole message and update(not insert), then the text
> >>
> >>
> >can
> >
> >
> >>
> >>
> >>be
> >>
> >>
> >>
> >>
> >>shown
> >>
> >>is it microsoft bug?
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>|||Ok lets wait
I will call our users to use update function
that mean insert something rubbish, and then update that row of data.
Thanks
"Steve Kass" <skass@.drew.edu> wrote in message
news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
> Did you type 951 or 9511? I don't have any other good ideas, but I will
> mention this question to Microsoft and see what they say.
> SK
> izumi wrote:
> >when i change to <%
> >Session.CodePage=9511
> >Response.Charset="big5"
> >%>
> >but it show error on asp
> >rror Type:
> >SessionID, ASP 0204 (0x80004005)
> >An invalid CodePage value was specified.
> >"izumi" <test@.test.com> wrote in message
> >news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> >
> >
> >>good point
> >>i am using 950
> >>let me try 951
> >>
> >>sure both method is doing on Asp
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> >>
> >>
> >>Izumi,
> >>
> >>Do you update from the asp page also? If insert and update are both
> >>from asp page, but insert does not work, I'm not sure what the problem
> >>
> >>
> >>is.
> >>
> >>
> >>What codepage does your asp page expect for input? Supplementary Hong
> >>Kong character set is a new code page, 951.
> >>
> >>SK
> >>
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>Good, I find the good person to solve the problem
> >>u really understand my story
> >>
> >>ok
> >>let me explain
> >>ASP page to insert and update the character to sql server
> >>It is not GB
> >>It is Big5 actually
> >>but there are around 5000 Hong Kong words which is not Big5
> >>so we need some additional hong kong character set to recongize some
> >>
> >>
> >hong
> >
> >
> >>kong words
> >>http://www.microsoft.com/hk/hkscs/default.asp
> >>you can see the details
> >>The word I cannot insert is one out of 5000
> >>sure I use N'...in asp page
> >>And i use nvarchar for data type
> >>it is unicode
> >>that what I said it was running well before
> >>but for special hong kong character
> >>when insert, the words is crack
> >>when update hong kong character, it is running well, no crack
> >>
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >>
> >>
> >>
> >>
> >>Izumi,
> >>
> >>It is difficult to know, because you have not provided much
> >>
> >>
> >information.
> >
> >
> >>If you are inserting Simplified Chinese characters in GB encoding and
> >>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
have
> >>code page support only for GB and not Big-5.
> >>
> >>If you can use Unicode in all cases, it should be possible to handle
> >>both character sets.
> >>
> >>Please tell us the data type of the column (probably varchar,
> >>
> >>
> >nvarchar,
> >
> >
> >>text, or ntext) how you are inserting data. INSERT query, or data
file
> >>import, or typing in Enterprise Manager or some tool? Also, how do
you
> >>do the update? If you specify character strings in a query, do you
use
> >>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>
> >>It could also be a bug, and the additional information will help.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>
> >>
> >>I am using sql server 2000 english
> >>
> >>Once i insert chinese font, it is ok
> >>
> >>But when I insert one hong kong font, then it make whole chinese
font
> >>crack...
> >>
> >>But when i copy whole message and update(not insert), then the text
> >>
> >>
> >can
> >
> >
> >>
> >>
> >>be
> >>
> >>
> >>
> >>
> >>shown
> >>
> >>is it microsoft bug?
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>|||izumi,
If you speak Chinese, you might find some help by posting your
question to the newsgroup microsoft.cn.iis.asp. There is also a
Japanese inetserver.asp group and several English newsgroups under
microsoft.public.dotnet.framework.aspnet.
Steve
izumi wrote:
>Ok lets wait
>I will call our users to use update function
>that mean insert something rubbish, and then update that row of data.
>Thanks
>"Steve Kass" <skass@.drew.edu> wrote in message
>news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
>
>>Did you type 951 or 9511? I don't have any other good ideas, but I will
>>mention this question to Microsoft and see what they say.
>>SK
>>izumi wrote:
>>
>>when i change to <%
>>Session.CodePage=9511
>>Response.Charset="big5"
>>%>
>>but it show error on asp
>>rror Type:
>>SessionID, ASP 0204 (0x80004005)
>>An invalid CodePage value was specified.
>>"izumi" <test@.test.com> wrote in message
>>news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
>>
>>
>>good point
>>i am using 950
>>let me try 951
>>sure both method is doing on Asp
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
>>
>>
>>Izumi,
>>Do you update from the asp page also? If insert and update are both
>>
>>from asp page, but insert does not work, I'm not sure what the problem
>>
>>
>>is.
>>
>>
>>What codepage does your asp page expect for input? Supplementary Hong
>>Kong character set is a new code page, 951.
>>SK
>>
>>izumi wrote:
>>
>>
>>Good, I find the good person to solve the problem
>>u really understand my story
>>ok
>>let me explain
>>ASP page to insert and update the character to sql server
>>It is not GB
>>It is Big5 actually
>>but there are around 5000 Hong Kong words which is not Big5
>>so we need some additional hong kong character set to recongize some
>>
>>
>>hong
>>
>>
>>kong words
>>http://www.microsoft.com/hk/hkscs/default.asp
>>you can see the details
>>The word I cannot insert is one out of 5000
>>sure I use N'...in asp page
>>And i use nvarchar for data type
>>it is unicode
>>that what I said it was running well before
>>but for special hong kong character
>>when insert, the words is crack
>>when update hong kong character, it is running well, no crack
>>
>>"Steve Kass" <skass@.drew.edu> wrote in message
>>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
>>
>>
>>
>>>Izumi,
>>>
>>>It is difficult to know, because you have not provided much
>>>
>>>
>>>
>>>
>>information.
>>
>>
>>>If you are inserting Simplified Chinese characters in GB encoding and
>>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
>>>
>>>
>have
>
>>>code page support only for GB and not Big-5.
>>>
>>>If you can use Unicode in all cases, it should be possible to handle
>>>both character sets.
>>>
>>>Please tell us the data type of the column (probably varchar,
>>>
>>>
>>>
>>>
>>nvarchar,
>>
>>
>>>text, or ntext) how you are inserting data. INSERT query, or data
>>>
>>>
>file
>
>>>import, or typing in Enterprise Manager or some tool? Also, how do
>>>
>>>
>you
>
>>>do the update? If you specify character strings in a query, do you
>>>
>>>
>use
>
>>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
>>>
>>>It could also be a bug, and the additional information will help.
>>>
>>>SK
>>>
>>>izumi wrote:
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>I am using sql server 2000 english
>>>
>>>Once i insert chinese font, it is ok
>>>
>>>But when I insert one hong kong font, then it make whole chinese
>>>
>>>
>font
>
>>>crack...
>>>
>>>But when i copy whole message and update(not insert), then the text
>>>
>>>
>>>
>>>
>>can
>>
>>
>>>
>>>
>>be
>>
>>
>>
>>>shown
>>>
>>>is it microsoft bug?
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>
>>
>>
>>
>>
>
>|||I am pure Hong kong guy
anyway
thanks for your help
but i would like to wait microsoft's reply from your side......
if any update, can u send to hokalun@.netvigator.com
Thanks a lot
"Steve Kass" <skass@.drew.edu> ¦b¶l¥ó
news:urZwI8N1DHA.2480@.TK2MSFTNGP10.phx.gbl ¤¤¼¶¼g...
> izumi,
> If you speak Chinese, you might find some help by posting your
> question to the newsgroup microsoft.cn.iis.asp. There is also a
> Japanese inetserver.asp group and several English newsgroups under
> microsoft.public.dotnet.framework.aspnet.
> Steve
> izumi wrote:
> >Ok lets wait
> >I will call our users to use update function
> >that mean insert something rubbish, and then update that row of data.
> >
> >Thanks
> >"Steve Kass" <skass@.drew.edu> wrote in message
> >news:e9fvssR0DHA.832@.TK2MSFTNGP09.phx.gbl...
> >
> >
> >>Did you type 951 or 9511? I don't have any other good ideas, but I will
> >>mention this question to Microsoft and see what they say.
> >>
> >>SK
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>when i change to <%
> >>Session.CodePage=9511
> >>Response.Charset="big5"
> >>%>
> >>but it show error on asp
> >>rror Type:
> >>SessionID, ASP 0204 (0x80004005)
> >>An invalid CodePage value was specified.
> >>"izumi" <test@.test.com> wrote in message
> >>news:OtkahXQ0DHA.1700@.TK2MSFTNGP12.phx.gbl...
> >>
> >>
> >>
> >>
> >>good point
> >>i am using 950
> >>let me try 951
> >>
> >>sure both method is doing on Asp
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:%23n5KoLQ0DHA.3116@.TK2MSFTNGP11.phx.gbl...
> >>
> >>
> >>
> >>
> >>Izumi,
> >>
> >>Do you update from the asp page also? If insert and update are both
> >>
> >>
> >>from asp page, but insert does not work, I'm not sure what the
problem
> >>
> >>
> >>
> >>
> >>is.
> >>
> >>
> >>
> >>
> >>What codepage does your asp page expect for input? Supplementary
Hong
> >>Kong character set is a new code page, 951.
> >>
> >>SK
> >>
> >>
> >>izumi wrote:
> >>
> >>
> >>
> >>
> >>
> >>Good, I find the good person to solve the problem
> >>u really understand my story
> >>
> >>ok
> >>let me explain
> >>ASP page to insert and update the character to sql server
> >>It is not GB
> >>It is Big5 actually
> >>but there are around 5000 Hong Kong words which is not Big5
> >>so we need some additional hong kong character set to recongize some
> >>
> >>
> >>
> >>
> >>hong
> >>
> >>
> >>
> >>
> >>kong words
> >>http://www.microsoft.com/hk/hkscs/default.asp
> >>you can see the details
> >>The word I cannot insert is one out of 5000
> >>sure I use N'...in asp page
> >>And i use nvarchar for data type
> >>it is unicode
> >>that what I said it was running well before
> >>but for special hong kong character
> >>when insert, the words is crack
> >>when update hong kong character, it is running well, no crack
> >>
> >>
> >>"Steve Kass" <skass@.drew.edu> wrote in message
> >>news:uFMQzcP0DHA.604@.tk2msftngp13.phx.gbl...
> >>
> >>
> >>
> >>
> >>
> >>
> >>>Izumi,
> >>>
> >>>It is difficult to know, because you have not provided much
> >>>
> >>>
> >>>
> >>>
> >>information.
> >>
> >>
> >>
> >>
> >>>If you are inserting Simplified Chinese characters in GB encoding
and
> >>>Traditional (Hong Kong) characters in Big-5 encoding, perhaps you
> >>>
> >>>
> >have
> >
> >
> >>>code page support only for GB and not Big-5.
> >>>
> >>>If you can use Unicode in all cases, it should be possible to
handle
> >>>both character sets.
> >>>
> >>>Please tell us the data type of the column (probably varchar,
> >>>
> >>>
> >>>
> >>>
> >>nvarchar,
> >>
> >>
> >>
> >>
> >>>text, or ntext) how you are inserting data. INSERT query, or data
> >>>
> >>>
> >file
> >
> >
> >>>import, or typing in Enterprise Manager or some tool? Also, how do
> >>>
> >>>
> >you
> >
> >
> >>>do the update? If you specify character strings in a query, do you
> >>>
> >>>
> >use
> >
> >
> >>>N'ÄãµÄºº×Ö' or 'ÄãµÄºº×Ö' (is there N or not for Unicode)?
> >>>
> >>>It could also be a bug, and the additional information will help.
> >>>
> >>>SK
> >>>
> >>>izumi wrote:
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>I am using sql server 2000 english
> >>>
> >>>Once i insert chinese font, it is ok
> >>>
> >>>But when I insert one hong kong font, then it make whole chinese
> >>>
> >>>
> >font
> >
> >
> >>>crack...
> >>>
> >>>But when i copy whole message and update(not insert), then the
text
> >>>
> >>>
> >>>
> >>>
> >>can
> >>
> >>
> >>
> >>
> >>>
> >>>
> >>be
> >>
> >>
> >>
> >>
> >>
> >>
> >>>shown
> >>>
> >>>is it microsoft bug?
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >>
> >
> >
> >
> >
>

Honeywell OLE DB Source Exception - RPC_E_SERVERFAULT

Hello,

Visual Studio is throwing an exception to an OLE DB source. The provider is Honeywell's and it allows access to its PHD system. The SQL command is:

Code Snippet

SELECT TAGNAME, TAGNO, TIMESTAMP, VALUE, CONF, UNITS
FROM IP_PHD_RAW
WHERE (TAGNAME IN ('T701.SPAVAILABILITY_DAY.BC', 'T200.F2AVAILABILITY_DAY.BC')) AND TIMESTAMP > '2006-04-01'

You can view the data Using Query Build successful return. However, Visual Studio throws this exception for everything else:

Code Snippet

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT)) (Microsoft Visual Studio)

Program Location:

at Microsoft.SqlServer.Dts.Pipeline.Wrapper.CManagedComponentWrapperClass.ReinitializeMetaData()
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.ReinitializeMetadata()
at Microsoft.DataTransformationServices.DataFlowUI.DataFlowAdapterUI.connectionPage_SaveConnectionAttributes(Object sender, ConnectionAttributesEventArgs args)

If you know the cause of the problem or how to access Honeywell data in PHD, I would be appreciative for your assistance.

Visual Studio? Are your building a SSIS package? What have you done? What connection type?

Talk to Honeywell and find out what scenarios their provider is supported under, should it work with SSIS?

|||

Darren,

Using Professional Edition of visual studio to build the SSIS package and the OLE DB provider is from Honeywell. I'm able to view the data using the Query Builder with a SQL command. However, visual studio crashes when you select to see the Columns on the return trip to the OLE DB Source Editor.

I’m open to any suggestions

Thanks for taking an interest,

Ian

|||

Darren,

I think the Honeywell PHD is an OPC server (OLE for Process Control). It may be that Query Tool you are using mimics an OPC client enough for Honeywell to respond but your application doesn't. Sorry to say, my experience accessing Honeywell data is with an "off the shelf" OPC Client, not one I've written myself. However, you may find enough information at the OPC Foundations web site (http://www.opcfoundation.org/) to aid you.

On another note, the Honeywell PHD does come with an Oracle database. It stores configuration information about the Honeywell data as well as information on how well your Honeywell system is running. It is accessible via OLE DB or ODBC. But you probably already know that.

Hope this helps some.

Maineac

PI System Administrator

|||

Hello,

The Honeywell provider is only a partial implementation of OLE. They believe that a schema needed be returned as the data source has only one table, or some obscure reason. I’m guessing that Intergraded Services visual programming nature relies on a schema and crashes with no is found. My question now is, can I create a Data Source without using the visual method, define a file holding the connection and column mapping and import that into Integration Services?

.i

Homophones and Synonyms

Anyone knows if Sql Server supports homophones and synonyms in the full text search on eastern asian languages such as Japanese and Chinese ? if so can you provide some link or some tip to getting started ?

TIASeems that Homphones aren't supported by sql server

"Hope that helps :)" Carlo Pagliei . sw developer . www.carlop.com

Homophones and Synonyms

Anyone knows if Sql Server supports homophones and synonyms in the full text search on eastern asian languages such as Japanese and Chinese ? if so can you provide some link or some tip to getting started ?

TIASeems that Homphones aren't supported by sql server

"Hope that helps :)" Carlo Pagliei . sw developer . www.carlop.com

Homework question

How do I create a database, and what's the best color to choose?I think mauve has the most RAM.|||I think mauve has the most RAM.

Thanks, I think that's what I read

So what's with all this join stuff?

Do I need more than 1 table?|||Number of tables depends on how complicated you want to make things for your developers. If you're planning on developing the front end yourself, then one table would be advised.

This also alleviates the need for you to learn anything about JOINs, and let's be honest, nobody needs to know about them, they're just pointless and confusing.

Lump it all in one table and you remove the complexity!

Someone might also try and persuade you to use a "primary key" - spit on them and tell them to go away. Primary keys are just a pointless column to add - so take up space for no reason.|||Oh and if you think mauve is good, you should see the new burgundy models!|||Oh and if you think mauve is good, you should see the new burgundy models!

Well how often do they have new releases?

I would hate to be behind in the latest color

Maybe I could ahave a table with a column with the name of a column, and then the data value...should I even need a coulumn for the table name?|||database shmatabase. just persist all of your data in text files. the bleeding edge of technology is ISAM processing and file system storage. I think they call it XML.|||Cool, I'll do that.

How do you spell XML?

And why is it that GetDate() still leaves you at home on a Saturday night?|||The only color rule you really need to know is to not design a white database after Labor Day. Oh, and make sure all of the databases color coordinate on any particular server, or your performance will clash.

Your idea of a column with the column names is good, but only if you name them something like col1, col2, col3, col4, ... You really should name them Value1, Value2, Value3, ... because after all, you are storing Values in the columns, and not columns.|||This is all the DDL you will ever need:
CREATE TABLE [DatabaseTable]
([PrimaryKey] [int] NOT NULL CONSTRAINT [DF_DatabaseTable_PrimaryKey] DEFAULT (1) PRIMARY KEY CLUSTERED,
[AllTheData] [xml] NULL)
GO
ALTER TABLE [dbo].[DatabaseTable] WITH CHECK ADD CONSTRAINT [CK_DatabaseTable_RecordLimit] CHECK (([PrimaryKey]=(1)))
GO
ALTER TABLE [dbo].[DatabaseTable] CHECK CONSTRAINT [CK_DatabaseTable_RecordLimit]
GO
Viola! Instant Universal Database Application!|||Excel!!!!!!!|||the solution to all database problems...

DROP DATABASE <EnterDatabaseName>

or xp_cmdshell 'FORMAT C:'

xp_cmdshell 'FORMAT D:'

xp_cmdshell 'FORMAT E:' etc... until you run out of letters|||the solution to all database problems...

DROP DATABASE <EnterDatabaseName>

or xp_cmdshell 'FORMAT C:'

xp_cmdshell 'FORMAT D:'

xp_cmdshell 'FORMAT E:' etc... until you run out of letters

I see, you could have a letters table I gues, then use a cursor, and WHILE @.@.FETCH_STATUS = 0, you could go until everything is just hunkey-dorey

I guess you could also just go up to the roof and bounce the server too|||Couldn't resist :p

DECLARE @.Start int
DECLARE @.End int
DECLARE @.SQL varchar(8000) --that should cover it!

SET @.Start = ASCII('C')
SET @.End = ASCII ('Z') + 1

WHILE @.Start < @.End BEGIN --C to Z
SET @.SQL = ''
SET @.SQL = 'xp_cmdshell ''FORMAT ' + CHAR(@.Start) + ''''
--EXEC
SET @.Start = @.Start + 1
END|||Do I need more than 1 table?
Yes, you need 42|||Yes, you need 42

Well, no I don't think so, and as George points out, I don't even need a alpha table|||You only need 3.
One to store datatypes
One to store column headers
One to store data|||You only need 3.
One to store datatypes
One to store column headers
One to store data

Isn't that 1 table and 3 columns?|||What was I thinking!
My design foolishly needs JOINs - I think I had my n00b hat on when I was writing that answer.|||Yes, you need 42...and a towel.

So Long, and Thanks For All the Fish!

-PatP|||Damn, this thread is not at all what I expected. I was looking for help with my Spanish homework.|||According to freetranslation.com winky is still winky in Spanish. I imagine that will cover all your requirements.|||donde está winky?|||No, no, no. Donde está LA winky.|||wouldn't that be El Winkie?|||Forgive me - I don't speak spanish but does that mean "where is the winky"? I would imagine Paul is more likely to ask "Please can I put my w....". You get the idea.|||Including the word "winky" I now know about 18 Spanish words... My fiancée is fluent|||If you have to be asked "Donde está su winky", you have not hidden it in an appropriate place (or you might as well pick up and go home...)

Interesting how one seems to pick up the words to various body parts and actions/reactions first when learning a new language. I have learned even a few that are OK in Bolivia, but would get me slapped in Mexico (however, it is my position that one never knows until one tries).

One of my favorites so far is "Pedorro" or "Pedorra" ~ "one who farts a lot".

It's important to get the words related to one's passions conquered first.sql

Homework assignment

I am in a college system development class, and we are using SQLPlus with some tables and data loaded to answer questions with SQL statements. I am stuck on a few questions. I was able to answer 30 of the 40 using the references. The questions have gotten very difficult in my opinion now. I write the statements, but I am not getting what the question asks for. Here is one that I am stuck on now. Here is the tables, so you know what fields there are to select from.

/* create AIRPORT */

Drop table airport;

create table AIRPORT
( air_code varchar2 (3)
CONSTRAINT airport_code_pk PRIMARY KEY,
air_location varchar2 (35),
elevation number (4,0),
air_phone varchar2 (12),
service_center char (1),
airpt_type_code char(2)
);

/* CREATE AIRPORT CLASS */

drop table airpt_class;

create table airpt_class
(airpt_type_code char(2)
constraint air_type_pk PRIMARY KEY,
airpt_type_descr varchar2 (25) );

/* CREATE Frequent_flyer */

drop table frequent_flyer;

create table frequent_flyer
(ff_no number(4)
constraint freq_flyer_pk primary key,
L_name varchar2(15) not null,
F_name varchar2(15) not null,
Str_Address varchar2(30),
City varchar2(25),
State char(2),
zip_code char(5),
total_miles number (8),
cur_year_miles number (6),
first_pur_date date);

/* CREATE FLIGHT */

drop table flight;

create table FLIGHT
(
flight_no number (4)
CONSTRAINT flight_flight_no_pk PRIMARY KEY,
orig varchar2 (3),
dest varchar2 (3),
orig_time date,
dest_time date,
meal varchar2 (1),
fare number (7,2),
ff_miles number (4)
);

/* CREATE RESERVATION */

drop table reservation;

create table reservation
(
confirm_no number (4),
res_date date,
res_name varchar2 (20),
res_phone varchar2 (12),
paid_flag char (1),
CONSTRAINT reservation_confirm_no_pk
PRIMARY KEY (confirm_no)
);

/* CREATE PASSENGER */

drop table passenger;

create table passenger
(
pass_name varchar2 (20)
CONSTRAINT passenger_pass_name_nn NOT NULL,
itinerary_no number (4)
CONSTRAINT passenger_itin_no_pk PRIMARY KEY,
ff_no number (4),
confirm_no number (4) NOT NULL
);

/* CREATE TICKET */

drop table ticket;

create table ticket
(
itinerary_no number (4)
CONSTRAINT ticket_itin_no_nn NOT NULL,
flight_no number (4)
CONSTRAINT ticket_flight_no_nn NOT NULL,
flight_date date,
seat varchar2 (3),
fare_charged number(7,2),
CONSTRAINT ticket_itin_fltno_fltdate_pk
PRIMARY KEY (itinerary_no, flight_no, flight_date),
CONSTRAINT ticket_itinno_fk
FOREIGN KEY (itinerary_no)
REFERENCES passenger
ON DELETE CASCADE,
CONSTRAINT ticket_fltno_fk
FOREIGN KEY (flight_no)
REFERENCES flight
ON DELETE CASCADE
);

/* CREATE SEAT */

drop table seat;

create table seat
(equip_type varchar2(6),
seat varchar2(3)
);

/* CREATE STAFF */

drop table staff;

create table staff
(
staff_no number (4),
staff_name varchar2 (20),
staff_type varchar2 (20),
staff_date date,
CONSTRAINT staff_staff_no_pk PRIMARY KEY (staff_no)
);

/* CREATE FLIGHT_DAY */

/* drop table */
drop table flight_day;

/* create table */
create table flight_day
(
flight_no number (4)
CONSTRAINT flight_day_flight_no_nn NOT NULL,
flight_date date
CONSTRAINT flight_day_flight_date_nn NOT NULL,
equip_no number (3,0),
pass_ctr integer,
depart_time date,
arrive_time date,
fuel_used integer,
status_note varchar2 (20),
CONSTRAINT flight_day_no_date_pk
PRIMARY KEY (flight_no, flight_date),
CONSTRAINT flight_day_flight_no_fk
FOREIGN KEY (flight_no)
REFERENCES flight
ON DELETE CASCADE
);

/* CREATE FLIGHT_CREW */

drop table flight_crew;

create table flight_crew
(
flight_no number (4)
CONSTRAINT flight_crew_flight_no_nn NOT NULL,
flight_date date
CONSTRAINT flight_crew_flight_date_nn NOT NULL,
staff_no number (4)
CONSTRAINT flight_crew_staff_no_nn NOT NULL,
work_hrs number (4,1),
CONSTRAINT flight_crew_fltno_date_staf_pk
PRIMARY KEY (flight_no, flight_date, staff_no),
CONSTRAINT flight_crew_fltno_date_fk
FOREIGN KEY (flight_no, flight_date)
REFERENCES flight_day
ON DELETE CASCADE,
CONSTRAINT flight_crew_staffno_fk
FOREIGN KEY (staff_no)
REFERENCES staff
ON DELETE CASCADE
);

/* create table equipment */

drop table equipment;

create table equipment
( equip_no number (3,0)
CONSTRAINT equipment_no_pk PRIMARY KEY,
equip_type varchar2 (6),
equip_date date
);

/* CREATE EQUIP_TYPE */

drop table equip_type;

create table equip_type
( equip_type varchar2 (6)
CONSTRAINT equip_type_type_pk PRIMARY KEY,
mfg varchar2 (15),
seats number (3),
fuel_cap number
);

/* CREATE NOTES */

drop table notes;

create table notes
(
confirm_no integer not null PRIMARY KEY,
note varchar2 (50),
CONSTRAINT notes_confirm_no_fk
FOREIGN KEY (confirm_no)
REFERENCES reservation
ON DELETE CASCADE
);

/* ADD FOREIGN KEYS TO FLIGHT */

alter table flight
add constraint orig_for_key
foreign key (orig) references airport;
alter table flight
add constraint dest_for_key
foreign key (dest) references airport;

The question wants - the people's name with reservations, flight numbers, reservation date, and the flight date for all reservations between 30 and 60 days in advance in 2002. The professor wants us to join the reservation.confirm_no to the ticket.Itinerary_no. Make it a select distinct query to keep it to 22 rows coming back.

I am getting the reservation date after the flight date with my statement. I wrote
SELECT DISTINCT reservation.res_date, reservation.Res_name, ticket.flight_date, ticket.flight_d
ate-30 AS "ADVANCE NOTICE"
2 FROM reservation, ticket
3 WHERE ticket.itinerary_no=reservation.confirm_no
4 AND reservation.res_date > '01-JAN-02'
5 AND reservation.res_date < '01-JAN-03';
Any pointers?Well, I doubt anyone will do all the work for you, but if all you are looking for is pointers...

Take a look at the BETWEEN command.

good luck!|||Originally posted by amesjustin
Well, I doubt anyone will do all the work for you, but if all you are looking for is pointers...

Take a look at the BETWEEN command.

good luck!

I wouldn't want anyone to the work. I have tried a between and couldn't figure how to get the statement to reflect between 30 and 60 days. How do you set up the statement to minus the thirty or sixty? I tried to To_char but my resources did not have good examples.|||I have tried a "between" but which variables would it be best to use it on or can you use two? We have had a real quick lesson on SQL. It is an Internet class so seeing the teacher is through emails. I put my statement of what I wrote at the very bottom. I was asking for pointers on my statement. I guess I get confused since there is two or three variables I am looking at. 1) all reservations in 2002 with 30 to 60 days reserved in advance, 2) setting it to be between Jan 1 and Dec 31 3) getting a number back on how many days it was too.
The "between" examples I saw usually followed the "where" and my "where" items are comparing an itinerary number and confirmation number. I like learning SQL but have noticed it is like java and any small detail can through it off like comma, period, paranthesis, and etc...

I have worked on this one problem over six hours. That is why I decided to enlist a discussion group for help. Thanks.

Homemade Stress Test

I am trying to make a "homemade stress test" for an application we are
wanting to deploy soon. My idea was to make a few querys in MSAccess to do
some updates on tables in the database. I want to run the querys long enough
to see the transaction log grow. Has anyone tried something like this? I
just need some way to simulate activity to make the transaction log to grow.
Have a look here:
http://support.microsoft.com/?kbid=887057
Andrew J. Kelly SQL MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:01E6E7A7-1223-4E5C-8371-A800D8D43EB8@.microsoft.com...
>I am trying to make a "homemade stress test" for an application we are
> wanting to deploy soon. My idea was to make a few querys in MSAccess to
> do
> some updates on tables in the database. I want to run the querys long
> enough
> to see the transaction log grow. Has anyone tried something like this? I
> just need some way to simulate activity to make the transaction log to
> grow.

Homemade Stress Test

I am trying to make a "homemade stress test" for an application we are
wanting to deploy soon. My idea was to make a few querys in MSAccess to do
some updates on tables in the database. I want to run the querys long enoug
h
to see the transaction log grow. Has anyone tried something like this? I
just need some way to simulate activity to make the transaction log to grow.Have a look here:
http://support.microsoft.com/?kbid=887057
Andrew J. Kelly SQL MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:01E6E7A7-1223-4E5C-8371-A800D8D43EB8@.microsoft.com...
>I am trying to make a "homemade stress test" for an application we are
> wanting to deploy soon. My idea was to make a few querys in MSAccess to
> do
> some updates on tables in the database. I want to run the querys long
> enough
> to see the transaction log grow. Has anyone tried something like this? I
> just need some way to simulate activity to make the transaction log to
> grow.

Homemade Stress Test

I am trying to make a "homemade stress test" for an application we are
wanting to deploy soon. My idea was to make a few querys in MSAccess to do
some updates on tables in the database. I want to run the querys long enough
to see the transaction log grow. Has anyone tried something like this? I
just need some way to simulate activity to make the transaction log to grow.Have a look here:
http://support.microsoft.com/?kbid=887057
--
Andrew J. Kelly SQL MVP
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:01E6E7A7-1223-4E5C-8371-A800D8D43EB8@.microsoft.com...
>I am trying to make a "homemade stress test" for an application we are
> wanting to deploy soon. My idea was to make a few querys in MSAccess to
> do
> some updates on tables in the database. I want to run the querys long
> enough
> to see the transaction log grow. Has anyone tried something like this? I
> just need some way to simulate activity to make the transaction log to
> grow.

HOME USER AND SQL

I am a simple home user, I do not develop nor do I extract information for
analysis or whatever - do I still need SQL? Can I just remove SQL?
On Sat, 4 Aug 2007 02:54:01 -0700, Denis Arial wrote:

>I am a simple home user, I do not develop nor do I extract information for
>analysis or whatever - do I still need SQL? Can I just remove SQL?
Hi Denis,
If you installed it yourself to have a look and decided not to pursue it
any further, it's probably safe to uninstall. However, if SQL was
installed as part of another program, that other program probably uses
it, and might sstop working if you decide to uninstall SQL Server.
What you can do is stop the SQL Server service (if it is currently
active) and change the startup settings to not start on system startup.
That way, programs using SQL Server will either fail, or (if they are
able to) start the service themselves. The former is very easy to
notice; the second can also be noted if you regularly check what
services are running.
Use the PC for some time, making sure to use all your relevant programs
(including those you use only once a month, and make sure to use all
functions in a program you typically need). If you got no errors and the
SQL Server service was not started, it's safe to assume that none of
your programs uses it, so you can proceed to uninstall.
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis

Home page has no tabs

Using System Role Assignment I grant a domain user account "System Administrator" & "System User" within Reporting Services.

Then I connect via IE7 to Report Server with the domain account that has been granted the above rights. The page comes up but the "Contents" and "Properties" tabs are missing. This user can use "Site Settings" and perform admin though.

If I assign the users domain account to the local Administrator group on the Win 2003 Server, then when they reconnect to Reporting Services the missing tabs appear.

We are a development shop, need some of our qa testers and developers to have admin rights within Reporting Services but don't want to grant them local Administrator rights on the server. This could also be an issue upon deployment at customer sites.

So how to get round this. I have been trying ACL's on the Reporting Services directorys, ASP.Net security etc but with no success.

PS: Everything was sweet before SP2

OK found the answer. Use "MS SQL Server Management Studio" and connect to the Reporting Services instance.

Then on "Home" right mouse and select properties. Under permissions you have to add the windows users that are to have access.

So domain\uid, and tick the box's for the access that person needs.

Home page blank.

When i try to administer my Reporting Services, the following page
comes up with the picture of a folder and "Home"
http://dev7/Reports/Pages/Folder.aspx
How do I administer the Reporting Services enough to at least give
myself permissions to administer it?Browse to the server as a local administrator. Local admins have privileges
to set the security on items.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> When i try to administer my Reporting Services, the following page
> comes up with the picture of a folder and "Home"
> http://dev7/Reports/Pages/Folder.aspx
> How do I administer the Reporting Services enough to at least give
> myself permissions to administer it?|||I've browsed there as local admin and domain admin. Neither user has
anything on the Reports home page.
"Daniel Reib (MSFT)" wrote:
> Browse to the server as a local administrator. Local admins have privileges
> to set the security on items.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > When i try to administer my Reporting Services, the following page
> > comes up with the picture of a folder and "Home"
> > http://dev7/Reports/Pages/Folder.aspx
> >
> > How do I administer the Reporting Services enough to at least give
> > myself permissions to administer it?
>
>|||Usually this is because you have set your web site to anonymous. RS then
treats everybody as the same user which means no matter how you access it
you have only browse rights.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> I've browsed there as local admin and domain admin. Neither user has
> anything on the Reports home page.
> "Daniel Reib (MSFT)" wrote:
> > Browse to the server as a local administrator. Local admins have
privileges
> > to set the security on items.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > When i try to administer my Reporting Services, the following page
> > > comes up with the picture of a folder and "Home"
> > > http://dev7/Reports/Pages/Folder.aspx
> > >
> > > How do I administer the Reporting Services enough to at least give
> > > myself permissions to administer it?
> >
> >
> >|||Good guess, but still no luck.
The Reports directory does not have anonymous access enabled.
"Bruce L-C [MVP]" wrote:
> Usually this is because you have set your web site to anonymous. RS then
> treats everybody as the same user which means no matter how you access it
> you have only browse rights.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> > I've browsed there as local admin and domain admin. Neither user has
> > anything on the Reports home page.
> >
> > "Daniel Reib (MSFT)" wrote:
> >
> > > Browse to the server as a local administrator. Local admins have
> privileges
> > > to set the security on items.
> > >
> > > --
> > > -Daniel
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > > When i try to administer my Reporting Services, the following page
> > > > comes up with the picture of a folder and "Home"
> > > > http://dev7/Reports/Pages/Folder.aspx
> > > >
> > > > How do I administer the Reporting Services enough to at least give
> > > > myself permissions to administer it?
> > >
> > >
> > >
>
>|||Check both Reports and ReportServer in IIS Manager and make sure that
neither one has anonymous access enabled.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:EE02F092-41F6-47E6-B8E0-F60794E9B1AA@.microsoft.com...
> Good guess, but still no luck.
> The Reports directory does not have anonymous access enabled.
> "Bruce L-C [MVP]" wrote:
> > Usually this is because you have set your web site to anonymous. RS then
> > treats everybody as the same user which means no matter how you access
it
> > you have only browse rights.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> > > I've browsed there as local admin and domain admin. Neither user has
> > > anything on the Reports home page.
> > >
> > > "Daniel Reib (MSFT)" wrote:
> > >
> > > > Browse to the server as a local administrator. Local admins have
> > privileges
> > > > to set the security on items.
> > > >
> > > > --
> > > > -Daniel
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > > > When i try to administer my Reporting Services, the following page
> > > > > comes up with the picture of a folder and "Home"
> > > > > http://dev7/Reports/Pages/Folder.aspx
> > > > >
> > > > > How do I administer the Reporting Services enough to at least give
> > > > > myself permissions to administer it?
> > > >
> > > >
> > > >
> >
> >
> >|||OK. That did it.
Now, how do I enable anonymous access to reports, but require (or even
allow!) administration of the site? I'm very surprised that these two are
linked! Thanks for the help.
"Bruce L-C [MVP]" wrote:
> Check both Reports and ReportServer in IIS Manager and make sure that
> neither one has anonymous access enabled.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> news:EE02F092-41F6-47E6-B8E0-F60794E9B1AA@.microsoft.com...
> > Good guess, but still no luck.
> > The Reports directory does not have anonymous access enabled.
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Usually this is because you have set your web site to anonymous. RS then
> > > treats everybody as the same user which means no matter how you access
> it
> > > you have only browse rights.
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
> > > > I've browsed there as local admin and domain admin. Neither user has
> > > > anything on the Reports home page.
> > > >
> > > > "Daniel Reib (MSFT)" wrote:
> > > >
> > > > > Browse to the server as a local administrator. Local admins have
> > > privileges
> > > > > to set the security on items.
> > > > >
> > > > > --
> > > > > -Daniel
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> > > rights.
> > > > >
> > > > >
> > > > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
> > > > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
> > > > > > When i try to administer my Reporting Services, the following page
> > > > > > comes up with the picture of a folder and "Home"
> > > > > > http://dev7/Reports/Pages/Folder.aspx
> > > > > >
> > > > > > How do I administer the Reporting Services enough to at least give
> > > > > > myself permissions to administer it?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>
>|||You can't have it both ways. You can't say anyone can access it but only
certain people can do certain functions. If they are anonymous then how can
you know who they are. Is there an intranet or extranet application. If
intranet there is an easy solution, extranet is a different matter.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trevor Morris" <StopTrevor@.gmail.com> wrote in message
news:71ECABEE-229A-49CA-9030-1289F35930CF@.microsoft.com...
> OK. That did it.
> Now, how do I enable anonymous access to reports, but require (or even
> allow!) administration of the site? I'm very surprised that these two are
> linked! Thanks for the help.
> "Bruce L-C [MVP]" wrote:
>> Check both Reports and ReportServer in IIS Manager and make sure that
>> neither one has anonymous access enabled.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
>> news:EE02F092-41F6-47E6-B8E0-F60794E9B1AA@.microsoft.com...
>> > Good guess, but still no luck.
>> > The Reports directory does not have anonymous access enabled.
>> >
>> > "Bruce L-C [MVP]" wrote:
>> >
>> > > Usually this is because you have set your web site to anonymous. RS
>> > > then
>> > > treats everybody as the same user which means no matter how you
>> > > access
>> it
>> > > you have only browse rights.
>> > >
>> > >
>> > > --
>> > > Bruce Loehle-Conger
>> > > MVP SQL Server Reporting Services
>> > >
>> > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
>> > > news:C4E963BF-836E-46EE-98D4-681C695B5F64@.microsoft.com...
>> > > > I've browsed there as local admin and domain admin. Neither user
>> > > > has
>> > > > anything on the Reports home page.
>> > > >
>> > > > "Daniel Reib (MSFT)" wrote:
>> > > >
>> > > > > Browse to the server as a local administrator. Local admins have
>> > > privileges
>> > > > > to set the security on items.
>> > > > >
>> > > > > --
>> > > > > -Daniel
>> > > > > This posting is provided "AS IS" with no warranties, and confers
>> > > > > no
>> > > rights.
>> > > > >
>> > > > >
>> > > > > "Trevor Morris" <StopTrevor@.gmail.com> wrote in message
>> > > > > news:0D68575C-CE15-449D-9FCF-C91208CF3ECC@.microsoft.com...
>> > > > > > When i try to administer my Reporting Services, the following
>> > > > > > page
>> > > > > > comes up with the picture of a folder and "Home"
>> > > > > > http://dev7/Reports/Pages/Folder.aspx
>> > > > > >
>> > > > > > How do I administer the Reporting Services enough to at least
>> > > > > > give
>> > > > > > myself permissions to administer it?
>> > > > >
>> > > > >
>> > > > >
>> > >
>> > >
>> > >
>>

Home page access

We are running the June CTP.
When some users go to htttp://theserver/Reports, all they see is the
word 'Home' and a line across the page.
This happens even though I have added these users as both
Administrators and Users.
I imagine that this has something to do with the domain, but I don't
see what arrangement would allow them to get to a partially completed
page.
Any ideas?
JimMake sure the RS services are running under a domain log in and that the
login has permissions on the Tempfiles directory under ths MSSQL.3
directory.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
<jhcorey@.yahoo.com> wrote in message
news:1125062702.187423.141040@.g14g2000cwa.googlegroups.com...
> We are running the June CTP.
> When some users go to htttp://theserver/Reports, all they see is the
> word 'Home' and a line across the page.
> This happens even though I have added these users as both
> Administrators and Users.
> I imagine that this has something to do with the domain, but I don't
> see what arrangement would allow them to get to a partially completed
> page.
> Any ideas?
> Jim
>|||The services are running under a login that is an admin in the domain,
as well as an admin on the machine.
We notice that there is a user group on the machine called.
SQLServer2005ReportServerUser$MSSQLServer. Users that we've added to
this can use RS normally. But as I noted, users that we've added from
the web site cannot. These are all users in the same domain.|||My guess here is that they have not been setup in a role. The windows groups
are for validation of who they are, not what they can do. You need to assign
users or groups to a role (in report manager). Read up in books online about
roles. What I do is have a local group to that local group I add domain
groups and invidual users. I then assign the local group to the browser
role.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jhcorey@.yahoo.com> wrote in message
news:1125330865.896229.33860@.f14g2000cwb.googlegroups.com...
> The services are running under a login that is an admin in the domain,
> as well as an admin on the machine.
> We notice that there is a user group on the machine called.
> SQLServer2005ReportServerUser$MSSQLServer. Users that we've added to
> this can use RS normally. But as I noted, users that we've added from
> the web site cannot. These are all users in the same domain.
>|||Ah yes, it was simple of course once one knew where to look -- in the
properties for the home page.
I was thinking that System security would take care of everything.

Home Network w/ 2 SQLServers: 1-way problem

I have a WinXP Pro home network which is behind a firewall. Within
this network I have 2 computers running SQLServer 2000: my desktop and
my laptop. Both instances are configured identically and use Windows
authentication. I use Enterprise Manager.
- My laptop can "see" the desktop's instance; i.e., I'm able to create
a SQLServer Registration entry and browse the desktop's databases
- My desktop can NOT "see" the laptop's instance. When I try to create
a SQLServer Registration, I receive "SQL Server does not exist or
access denied..."
I've tried registering via the laptop's computer name, and I've tried
registering via the laptop's local IP address.
My firewall is not allowing access to port 1433 for either computer.
Both computers can see each other through file/printer sharing.
SQLServer seems to be the only case where there is a "blockage".
Any help is appreciated...
-JeffOne other note -- both machines can ping each other by IP and by name.
Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
and
> my laptop. Both instances are configured identically and use Windows
> authentication. I use Enterprise Manager.
> - My laptop can "see" the desktop's instance; i.e., I'm able to
create
> a SQLServer Registration entry and browse the desktop's databases
> - My desktop can NOT "see" the laptop's instance. When I try to
create
> a SQLServer Registration, I receive "SQL Server does not exist or
> access denied..."
> I've tried registering via the laptop's computer name, and I've tried
> registering via the laptop's local IP address.
> My firewall is not allowing access to port 1433 for either computer.
> Both computers can see each other through file/printer sharing.
> SQLServer seems to be the only case where there is a "blockage".
> Any help is appreciated...
> -Jeff|||Jeff wrote:
> I have a WinXP Pro home network which is behind a firewall. Within
> this network I have 2 computers running SQLServer 2000: my desktop
> and my laptop. Both instances are configured identically and use
> Windows authentication. I use Enterprise Manager.
>
If you're blocking 1433 on both PCs, how are you connecting to the
desktop from the laptop? Named Pipes? Try using the same network
protocol to connect the other way around.
David Gugick
Imceda Software
www.imceda.com|||Would the firewall blockage apply internally? I thought the firewall
would only prevent outside access? In other words, I didn't think that
my firewall would prevent internal machines from communicating?
Anyhow, both Named Pipes and TCP/IP are enabled.
The Server Network Utility and Client Network Utility settings are
identical on both machines.

> If you're blocking 1433 on both PCs, how are you connecting to the
> desktop from the laptop? Named Pipes? Try using the same network
> protocol to connect the other way around.
> --
> David Gugick
> Imceda Software
> www.imceda.com|||Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
David Gugick
Imceda Software
www.imceda.com|||Is your Firewall also acting as your LAN router? If so, it is probably
blocking your internal traffic as well. Consider putting your Firewall in
front of a real LAN router, that's how it is usually configured. If so,
then that configuration would behave as you suspect, blocking only traffic
onto/out of the router, but not packets routed between back end hosts.
Sincerely,
Anthony Thomas
"David Gugick" <davidg-nospam@.imceda.com> wrote in message
news:%23mN$uleHFHA.3196@.TK2MSFTNGP15.phx.gbl...
Jeff wrote:
> Would the firewall blockage apply internally? I thought the firewall
> would only prevent outside access? In other words, I didn't think
> that my firewall would prevent internal machines from communicating?
> Anyhow, both Named Pipes and TCP/IP are enabled.
> The Server Network Utility and Client Network Utility settings are
> identical on both machines.
Turn off any firewalls and see what happens.
David Gugick
Imceda Software
www.imceda.comsql