Yes, I am trying to migrate a few SQL servers from NT4
domain to the new AD domain. These SQL servers have many
Windows authenticated SQL user account. As I understand,
once the logins have been defined as <NT4
domain>\<username>, we cant change it to <AD
domain>\<username>, unless we delete the logins and
recreate it again?
The article (http://support.microsoft.com/default.aspx?
scid=kb;EN-US;240872) seems to mention the moving of
database from one server to another. However in my case,
the database will remain in the same server, just that
the domain will change...hence affecting all the
previously created Windows authenticated SQL user
accounts.
Is there any step-by-step document on how to do security
translation for these SQL user accounts after the
migration to the new domain?
>--Original Message--
>Message unavailableSomething like this ... it's been awhile ... SQL Server maps SIDS to SQL Se
rver id's. There's a technique/procedure that help to remap these when like
your self domain SIDS don't match up with SQL Server id's. Sorry, but I do
nt' do it often enough to r
emember exactly.
Showing posts with label windows. Show all posts
Showing posts with label windows. Show all posts
Friday, March 30, 2012
Impact of AD Migration on Windows authenticated SQL user account
We have SQL applications in which some of the SQL user
accounts are integrated with Windows authentication.
We would like to find out whether any of you have
migrated any SQL based applications of which the SQL user
accounts were configured to make use of Windows
authentication instead of SQL authentication. Will the
Windows accounts in SQL be automatically translated to
the new AD account (with all necessary SQL
rights/permissions) or do we have to manually recreate &
reconfigure all Windows accounts in SQL and its
rights/permissions?
Appreciate some feedback. Thanks.
.Hi
If you are using the AD migration tool then you should keep the same SIDs
and therefore there should not be a problem.
If you do change SIDS then the amount of rework would be reduced if you used
NT groups when granting premissions rather than individual users.
John
"Teo Chee Yang" <anonymous@.discussions.microsoft.com> wrote in message
news:c11b01c40893$25655870$a301280a@.phx.gbl...
> We have SQL applications in which some of the SQL user
> accounts are integrated with Windows authentication.
> We would like to find out whether any of you have
> migrated any SQL based applications of which the SQL user
> accounts were configured to make use of Windows
> authentication instead of SQL authentication. Will the
> Windows accounts in SQL be automatically translated to
> the new AD account (with all necessary SQL
> rights/permissions) or do we have to manually recreate &
> reconfigure all Windows accounts in SQL and its
> rights/permissions?
> Appreciate some feedback. Thanks.
> .
>|||Personally I doubt that ADMT does translate any SQL
permissions and rights assigned to Windows-authenticated
SQL user accounts.
Besides, I realized that from the Security, Logins folder
that once the logins are defined as <NT4
domain>\<username>, we cant changed it, even before the
migration of the SQL server computer account.
Any more feedback?
>--Original Message--
>Hi
>If you are using the AD migration tool then you should
keep the same SIDs
>and therefore there should not be a problem.
>If you do change SIDS then the amount of rework would be
reduced if you used
>NT groups when granting premissions rather than
individual users.
>John
>"Teo Chee Yang" <anonymous@.discussions.microsoft.com>
wrote in message
>news:c11b01c40893$25655870$a301280a@.phx.gbl...
user
&
>
>.
>|||Hi
This sounds like you are changing the domain as well during the migration.
In which case look at:
http://support.microsoft.com/defaul...kb;EN-US;240872
I believe in the documentation that SIDs are retained by ADMT, if it did not
all sorts of other privilege related problems would occur.
John
"Teo Chee Yang" <anonymous@.discussions.microsoft.com> wrote in message
news:c64d01c40915$7d155610$a401280a@.phx.gbl...
> Personally I doubt that ADMT does translate any SQL
> permissions and rights assigned to Windows-authenticated
> SQL user accounts.
> Besides, I realized that from the Security, Logins folder
> that once the logins are defined as <NT4
> domain>\<username>, we cant changed it, even before the
> migration of the SQL server computer account.
> Any more feedback?
>
> keep the same SIDs
> reduced if you used
> individual users.
> wrote in message
> user
> &
accounts are integrated with Windows authentication.
We would like to find out whether any of you have
migrated any SQL based applications of which the SQL user
accounts were configured to make use of Windows
authentication instead of SQL authentication. Will the
Windows accounts in SQL be automatically translated to
the new AD account (with all necessary SQL
rights/permissions) or do we have to manually recreate &
reconfigure all Windows accounts in SQL and its
rights/permissions?
Appreciate some feedback. Thanks.
.Hi
If you are using the AD migration tool then you should keep the same SIDs
and therefore there should not be a problem.
If you do change SIDS then the amount of rework would be reduced if you used
NT groups when granting premissions rather than individual users.
John
"Teo Chee Yang" <anonymous@.discussions.microsoft.com> wrote in message
news:c11b01c40893$25655870$a301280a@.phx.gbl...
> We have SQL applications in which some of the SQL user
> accounts are integrated with Windows authentication.
> We would like to find out whether any of you have
> migrated any SQL based applications of which the SQL user
> accounts were configured to make use of Windows
> authentication instead of SQL authentication. Will the
> Windows accounts in SQL be automatically translated to
> the new AD account (with all necessary SQL
> rights/permissions) or do we have to manually recreate &
> reconfigure all Windows accounts in SQL and its
> rights/permissions?
> Appreciate some feedback. Thanks.
> .
>|||Personally I doubt that ADMT does translate any SQL
permissions and rights assigned to Windows-authenticated
SQL user accounts.
Besides, I realized that from the Security, Logins folder
that once the logins are defined as <NT4
domain>\<username>, we cant changed it, even before the
migration of the SQL server computer account.
Any more feedback?
>--Original Message--
>Hi
>If you are using the AD migration tool then you should
keep the same SIDs
>and therefore there should not be a problem.
>If you do change SIDS then the amount of rework would be
reduced if you used
>NT groups when granting premissions rather than
individual users.
>John
>"Teo Chee Yang" <anonymous@.discussions.microsoft.com>
wrote in message
>news:c11b01c40893$25655870$a301280a@.phx.gbl...
user
&
>
>.
>|||Hi
This sounds like you are changing the domain as well during the migration.
In which case look at:
http://support.microsoft.com/defaul...kb;EN-US;240872
I believe in the documentation that SIDs are retained by ADMT, if it did not
all sorts of other privilege related problems would occur.
John
"Teo Chee Yang" <anonymous@.discussions.microsoft.com> wrote in message
news:c64d01c40915$7d155610$a401280a@.phx.gbl...
> Personally I doubt that ADMT does translate any SQL
> permissions and rights assigned to Windows-authenticated
> SQL user accounts.
> Besides, I realized that from the Security, Logins folder
> that once the logins are defined as <NT4
> domain>\<username>, we cant changed it, even before the
> migration of the SQL server computer account.
> Any more feedback?
>
> keep the same SIDs
> reduced if you used
> individual users.
> wrote in message
> user
> &
Impact if Change Server ame
I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the testing
and ready to go. But we need to change the Windows server name, which means
the default instance name will be changed automatically. What's the impace
on database, or database setting or SQL server settings?
Thanks
Shouldn't be any, unless you have remote logins (e.g. for replication), or
have hard-coded the old server name in your code, or have linked servers
pointing at aliases that reference the server by its old name as opposed to
IP.
Just make sure you do:
EXEC sp_dropserver 'old name'
GO
EXEC sp_addserver 'new name', local
http://www.aspfaq.com/
(Reverse address to reply.)
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
> I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
testing
> and ready to go. But we need to change the Windows server name, which
means
> the default instance name will be changed automatically. What's the
impace
> on database, or database setting or SQL server settings?
> Thanks
|||also watch out for the problem with jobs as per below
http://support.microsoft.com/default...b;en-us;281642
Andy.
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
>I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
>testing
> and ready to go. But we need to change the Windows server name, which
> means
> the default instance name will be changed automatically. What's the
> impace
> on database, or database setting or SQL server settings?
> Thanks
and ready to go. But we need to change the Windows server name, which means
the default instance name will be changed automatically. What's the impace
on database, or database setting or SQL server settings?
Thanks
Shouldn't be any, unless you have remote logins (e.g. for replication), or
have hard-coded the old server name in your code, or have linked servers
pointing at aliases that reference the server by its old name as opposed to
IP.
Just make sure you do:
EXEC sp_dropserver 'old name'
GO
EXEC sp_addserver 'new name', local
http://www.aspfaq.com/
(Reverse address to reply.)
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
> I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
testing
> and ready to go. But we need to change the Windows server name, which
means
> the default instance name will be changed automatically. What's the
impace
> on database, or database setting or SQL server settings?
> Thanks
|||also watch out for the problem with jobs as per below
http://support.microsoft.com/default...b;en-us;281642
Andy.
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
>I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
>testing
> and ready to go. But we need to change the Windows server name, which
> means
> the default instance name will be changed automatically. What's the
> impace
> on database, or database setting or SQL server settings?
> Thanks
Impact if Change Server ame
I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the testing
and ready to go. But we need to change the Windows server name, which means
the default instance name will be changed automatically. What's the impace
on database, or database setting or SQL server settings?
ThanksShouldn't be any, unless you have remote logins (e.g. for replication), or
have hard-coded the old server name in your code, or have linked servers
pointing at aliases that reference the server by its old name as opposed to
IP.
Just make sure you do:
EXEC sp_dropserver 'old name'
GO
EXEC sp_addserver 'new name', local
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
> I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
testing
> and ready to go. But we need to change the Windows server name, which
means
> the default instance name will be changed automatically. What's the
impace
> on database, or database setting or SQL server settings?
> Thanks|||also watch out for the problem with jobs as per below
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
Andy.
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
>I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
>testing
> and ready to go. But we need to change the Windows server name, which
> means
> the default instance name will be changed automatically. What's the
> impace
> on database, or database setting or SQL server settings?
> Thanks
and ready to go. But we need to change the Windows server name, which means
the default instance name will be changed automatically. What's the impace
on database, or database setting or SQL server settings?
ThanksShouldn't be any, unless you have remote logins (e.g. for replication), or
have hard-coded the old server name in your code, or have linked servers
pointing at aliases that reference the server by its old name as opposed to
IP.
Just make sure you do:
EXEC sp_dropserver 'old name'
GO
EXEC sp_addserver 'new name', local
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
> I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
testing
> and ready to go. But we need to change the Windows server name, which
means
> the default instance name will be changed automatically. What's the
impace
> on database, or database setting or SQL server settings?
> Thanks|||also watch out for the problem with jobs as per below
http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
Andy.
"Maggie" <Maggie@.discussions.microsoft.com> wrote in message
news:6CCC918E-573C-44E5-B3C1-7733CC680A75@.microsoft.com...
>I built SQL Server 2k ent sp3a on Windows 2003 ent and completed the
>testing
> and ready to go. But we need to change the Windows server name, which
> means
> the default instance name will be changed automatically. What's the
> impace
> on database, or database setting or SQL server settings?
> Thanks
Immediate Updating Subscription - Hangs
We have installed SQL Server 2000 on a new server running Windows 2003.
This server is the distirbution Server. It also contains a one database. THis database subscibes to data from other servers and publishes data to other servers.
One of the publications is an updateable subscription. Ths subscription is pushed to the subscriber.
The replication works fine from publisher to subscriber, but when the subscriber attempts an update it just hangs. I see no blocking on either server.
DTC is running on both servers. I executed sp_link_pubisher on the subscriber to populate the publisher login and password in the MSsubscription_properties table.
I must be missing something else.
Can anyone help?
When you say it hangs do you mean it is slow or it doesn't work?
Do you eventually get an error message saying "Access denied"?
If you get this error message, DTC on your Subcriber cannot talk to your Publisher. Its either a name resolution problem, or more likely a permissions problem. Check the accound your SQL Server agent runs under on the Susbcriber and make sure it is part o
f the local administrators group on your Publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Thank you Hilary for your prompt reply.
WHat I mean by it hangs is it never completes. And it doesn't appear to time out.
I do feel it is something to do with DTC. I will investigate the account SQL Server agent runs under on the Susbcriber
and make sure it is part of the local administrators group on the Publisher.
If you cant hink of anything else in the meantime, I am all ears.
Thanks again.
|||I verified that the account the SQL Server agent runs under on the Susbcriber is part of the local administrators group on the Publisher.
I do not get an "Access denied" error. I get no response at all.
Can you suggest anything else?
-- Hilary Cotter wrote: --
When you say it hangs do you mean it is slow or it doesn't work?
Do you eventually get an error message saying "Access denied"?
If you get this error message, DTC on your Subcriber cannot talk to your Publisher. Its either a name resolution problem, or more likely a permissions problem. Check the accound your SQL Server agent runs under on the Susbcriber and make sure it is p
art of the local administrators group on your Publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||what does your msdtc log say. It can be found in
C:\WINDOWS\System32\MSDtc
"casey@.newsgroups.nospam" <anonymous@.discussions.microsoft.com> wrote in
message news:24BA0D29-2D9B-417D-8730-3B2920FBF11B@.microsoft.com...
> I verified that the account the SQL Server agent runs under on the
Susbcriber is part of the local administrators group on the Publisher.
> I do not get an "Access denied" error. I get no response at all.
> Can you suggest anything else?
> -- Hilary Cotter wrote: --
> When you say it hangs do you mean it is slow or it doesn't work?
> Do you eventually get an error message saying "Access denied"?
> If you get this error message, DTC on your Subcriber cannot talk to
your Publisher. Its either a name resolution problem, or more likely a
permissions problem. Check the accound your SQL Server agent runs under on
the Susbcriber and make sure it is part of the local administrators group on
your Publisher.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
|||Helen,
The DTC log contains mostly non-displayable characters. Same for the Trace. Is there a tool I should be using to read this file?
|||My problem is resolved.
The trouble was that with Windows 2003, Enable network DTC access is not "enabled" by default. Once I enabled this, everything works fine.
Thanks for your help.
This server is the distirbution Server. It also contains a one database. THis database subscibes to data from other servers and publishes data to other servers.
One of the publications is an updateable subscription. Ths subscription is pushed to the subscriber.
The replication works fine from publisher to subscriber, but when the subscriber attempts an update it just hangs. I see no blocking on either server.
DTC is running on both servers. I executed sp_link_pubisher on the subscriber to populate the publisher login and password in the MSsubscription_properties table.
I must be missing something else.
Can anyone help?
When you say it hangs do you mean it is slow or it doesn't work?
Do you eventually get an error message saying "Access denied"?
If you get this error message, DTC on your Subcriber cannot talk to your Publisher. Its either a name resolution problem, or more likely a permissions problem. Check the accound your SQL Server agent runs under on the Susbcriber and make sure it is part o
f the local administrators group on your Publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||Thank you Hilary for your prompt reply.
WHat I mean by it hangs is it never completes. And it doesn't appear to time out.
I do feel it is something to do with DTC. I will investigate the account SQL Server agent runs under on the Susbcriber
and make sure it is part of the local administrators group on the Publisher.
If you cant hink of anything else in the meantime, I am all ears.
Thanks again.
|||I verified that the account the SQL Server agent runs under on the Susbcriber is part of the local administrators group on the Publisher.
I do not get an "Access denied" error. I get no response at all.
Can you suggest anything else?
-- Hilary Cotter wrote: --
When you say it hangs do you mean it is slow or it doesn't work?
Do you eventually get an error message saying "Access denied"?
If you get this error message, DTC on your Subcriber cannot talk to your Publisher. Its either a name resolution problem, or more likely a permissions problem. Check the accound your SQL Server agent runs under on the Susbcriber and make sure it is p
art of the local administrators group on your Publisher.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
|||what does your msdtc log say. It can be found in
C:\WINDOWS\System32\MSDtc
"casey@.newsgroups.nospam" <anonymous@.discussions.microsoft.com> wrote in
message news:24BA0D29-2D9B-417D-8730-3B2920FBF11B@.microsoft.com...
> I verified that the account the SQL Server agent runs under on the
Susbcriber is part of the local administrators group on the Publisher.
> I do not get an "Access denied" error. I get no response at all.
> Can you suggest anything else?
> -- Hilary Cotter wrote: --
> When you say it hangs do you mean it is slow or it doesn't work?
> Do you eventually get an error message saying "Access denied"?
> If you get this error message, DTC on your Subcriber cannot talk to
your Publisher. Its either a name resolution problem, or more likely a
permissions problem. Check the accound your SQL Server agent runs under on
the Susbcriber and make sure it is part of the local administrators group on
your Publisher.
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
>
|||Helen,
The DTC log contains mostly non-displayable characters. Same for the Trace. Is there a tool I should be using to read this file?
|||My problem is resolved.
The trouble was that with Windows 2003, Enable network DTC access is not "enabled" by default. Once I enabled this, everything works fine.
Thanks for your help.
Wednesday, March 28, 2012
I-Mate JasJar And compact framework installation Problem ?
Hi everyone here
i have a little problem :
i tried to install the compact framework onto my pocket pc with windows mobile 5.0
but the installation fiailed and gave me an error .
the error message said that :
the version of installation is not specified for this version of
operating system ..
so what can i do to install compact framework on the device ?
please help !
Which version of the Compact Framework? How exactly have you tried to install it? Is this message produced on desktop or device?
|||Hi
Which version of the Compact Framework?
NetCF 2.0
How exactly have you tried to install it?
i have copied the files :
X:\Program Files\Microsoft.NET\SDK\CompactFramework\v2.0\WindowsCE\wce500\armv4i\NETCFv2.wm.armv4i.cab
and run it .
Is this message produced on desktop or device?
after i installed the file above , i tried to run
an application uses the namespace System.Data.SqlServerCe
i got an error message said :
" File Or Assembly name 'System.Data.SqlServerCe , Version=3.0.3600.0, .....
...' , or one of its depenencies, was not found."
so what is the problem ?
regards
|||in regards to the SqlServerCE error message, SQL Server Mobile needs to be installed separate from the framework:
http://msdn2.microsoft.com/en-us/library/ms171938.aspx
|||You've got this message because your application is using SQL Mobile which you have to install separately from NETCF.
|||Hi
thank you for your response, but the problem happened after i had installed the SQLServerCe ..
is there another reason for this error message ?
Regards.
|||Either you’ve installed incorrect version (e.g. SQL CE 2.0 instead of SQL Mobile) or you’ve installed it before NETCF (which would suppress managed provider installation).
|||Hi
thanks for you
I have solved the problem by reinstalling the SqlServerCe, now everything is all right.
Regards
sqlImages do not display in Reporting Sevices on Windows 2003 Server
Hi,
I have reporting services installed on windows 2003 server.
Embedded Images do display in designer preview, but they do not display in
Report Manager or browser. When I use localhost instead of my machine name in
report url, then images are displayed. I have installed service pack 1 & 2
for RS. After that I installed SP4 for SQL Server. Can some body help in this
regard?
Thanks in anticipation.Hi
Following issue is resolved.
Please look at following link. "_" in the machine name is the
culprit. I used the IP and it worked fine. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Saeed Ahmad" wrote:
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in this
> regard?
> Thanks in anticipation.
>|||I've narrowed this down a bit. It seems to happen only with line art no
matter what file format your using (png, gif etc.) The only way I've found
around it (which isn't acceptable in my opinion) is to use the "fit"
parameter for the image.
From what I've read - RS sends a jscript to resize image in browser. I'm
guessing it fails to work because it is line art.
"Saeed Ahmad" <Saeed Ahmad@.discussions.microsoft.com> wrote in message
news:B47ABB44-24D6-433D-A621-9DCBE48690C1@.microsoft.com...
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name
> in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in
> this
> regard?
> Thanks in anticipation.
>sql
I have reporting services installed on windows 2003 server.
Embedded Images do display in designer preview, but they do not display in
Report Manager or browser. When I use localhost instead of my machine name in
report url, then images are displayed. I have installed service pack 1 & 2
for RS. After that I installed SP4 for SQL Server. Can some body help in this
regard?
Thanks in anticipation.Hi
Following issue is resolved.
Please look at following link. "_" in the machine name is the
culprit. I used the IP and it worked fine. Also replace machine name in
report server and report manager config files with machine IP address.
http://groups.google.com.pk/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/dc1fcfec0c41ec70/23425c9cbdabb2a1?q=%22reporting+services%22+%2B+%22images%22&rnum=1&hl=en#23425c9cbdabb2a1
"Saeed Ahmad" wrote:
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in this
> regard?
> Thanks in anticipation.
>|||I've narrowed this down a bit. It seems to happen only with line art no
matter what file format your using (png, gif etc.) The only way I've found
around it (which isn't acceptable in my opinion) is to use the "fit"
parameter for the image.
From what I've read - RS sends a jscript to resize image in browser. I'm
guessing it fails to work because it is line art.
"Saeed Ahmad" <Saeed Ahmad@.discussions.microsoft.com> wrote in message
news:B47ABB44-24D6-433D-A621-9DCBE48690C1@.microsoft.com...
> Hi,
> I have reporting services installed on windows 2003 server.
> Embedded Images do display in designer preview, but they do not display in
> Report Manager or browser. When I use localhost instead of my machine name
> in
> report url, then images are displayed. I have installed service pack 1 & 2
> for RS. After that I installed SP4 for SQL Server. Can some body help in
> this
> regard?
> Thanks in anticipation.
>sql
Friday, March 23, 2012
Image insertion to ss2005 from Windows Mobile
Hi ,
I am trynig to insert an image from the Windows mobile to the SQL database.
Is it possible to perform this using RDA ?
After some search in this forum , I got an impression that the only way to do this by storing the image in a local database and then do a merge replication.
I do not want to do the merge replcation just fo rthis reason.
Is it possible in RDA?
Debugging shows only some part of the data is getting updated.
While trying to retrieve the image in a webpage error is poping up.
My code is :
string strbytes = (Convert.ToBase64String(bytes)).ToString();
DbObj.GetSubmitSql("Update Odrs set SignedBy ='" + txtSign.Text + "', Signature = Convert(Image,'" + bytes + "') where OrderId=" + orderNo + "");
Please help....
No, that is not possible to do using SqlCeRemoteDataAccess.SubmitSql() which I presume you’re trying to use.
Use SQL Client and use parameters to pass a byte array with image instead.
Wednesday, March 21, 2012
Image field
Dear friends,
After inserting a word document in an image field, is it possible to
retrieve the same file and store it to some of the windows folder:
1. through SQL Server Stored Procedure?
2. though any other means like .Net code etc..
Thnaks in anticipation
Regards
Sathian> After inserting a word document in an image field, is it possible to
> retrieve the same file and store it to some of the windows folder:
> 1. through SQL Server Stored Procedure?
No idea, but would you want to? T-SQL was not designed for this.
> 2. though any other means like .Net code etc..
Absolutely. It's a piece of cake. Remember that an image field is nothing mo
re
than an array of bytes. All you do is creata a FileStream and set it's conte
nts
to that of the byte array from the image field.
Thomas|||Hello thomas,
Thank you very much.
Any sample piece of code wiich does so..?
I tried in net.. so far I wasn't sucessful..
Regards
Sathian
"Thomas" <thomas@.newsgroup.nospam> wrote in message
news:eoguWJXQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> No idea, but would you want to? T-SQL was not designed for this.
>
> Absolutely. It's a piece of cake. Remember that an image field is nothing
more
> than an array of bytes. All you do is creata a FileStream and set it's
contents
> to that of the byte array from the image field.
>
> Thomas
>|||Although this is not the forum for this sort of question...
private const string connStr = ...
public void ReadFromDBToFile(string destFilePath)
{
byte[] data = null;
using (SqlConnection conn = new SqlConnection(connStr))
{
StringBuilder sb = new StringBuilder();
sb.Append("Select Content, DataLength(Content) As Len");
sb.AppendFormat("\nFrom dbo.TableName");
sb.AppendFormat("\nWhere PK = @.PK");
conn.Open();
using (SqlCommand cmd = new SqlCommand(sb.ToString(), conn))
{
cmd.Parameters.Add("@.PK", SqlDbType...);
cmd.Parameters[0].Value = <pk>
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
int len = dr.GetInt32(1);
data = new byte[len];
dr.GetBytes(0, 0, data, 0, data.Length);
}
}
}
using (FileStream fs = new FileStream(destFilePath, FileMode.Create,
FileAccess.Write, FileShare.Write))
{
fs.Write(data, 0, data.Length);
}
}
public void WriteFromFileToDB(string sourceFilePath)
{
byte[] data;
using (FileStream fs = new FileStream(sourceFilePath, FileMode.Open,
FileAccess.Read, FileShare.Read))
{
data = new byte[fs.Length];
fs.Read(data, 0, (int)fs.Length);
}
using (SqlConnection conn = new SqlConnection(connStr))
{
StringBuilder sb = new StringBuilder();
sb.Append("Update dbo.TableName");
sb.AppendFormat("\nSet Content = @.Content");
sb.AppendFormat("\nWhere PK= @.PK");
conn.Open();
using (SqlCommand cmd = new SqlCommand(sb.ToString(), conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@.Content", SqlDbType.Image);
cmd.Parameters.Add("@.PK", SqlDbType...
cmd.Parameters[0].Value = data;
cmd.Parameters[1].Value = <pk>
cmd.ExecuteNonQuery();
}
}
}
I used a dynamic SQL statement, but you could just as easily use a stored pr
oc.
HTH
Thomas
"Sathian" <sathian.t@.in.bosch.com> wrote in message
news:d3nfqc$oem$1@.ns2.fe.internet.bosch.com...
> Hello thomas,
> Thank you very much.
> Any sample piece of code wiich does so..?
> I tried in net.. so far I wasn't sucessful..
> Regards
> Sathian
> "Thomas" <thomas@.newsgroup.nospam> wrote in message
> news:eoguWJXQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> more
> contents
>
After inserting a word document in an image field, is it possible to
retrieve the same file and store it to some of the windows folder:
1. through SQL Server Stored Procedure?
2. though any other means like .Net code etc..
Thnaks in anticipation
Regards
Sathian> After inserting a word document in an image field, is it possible to
> retrieve the same file and store it to some of the windows folder:
> 1. through SQL Server Stored Procedure?
No idea, but would you want to? T-SQL was not designed for this.
> 2. though any other means like .Net code etc..
Absolutely. It's a piece of cake. Remember that an image field is nothing mo
re
than an array of bytes. All you do is creata a FileStream and set it's conte
nts
to that of the byte array from the image field.
Thomas|||Hello thomas,
Thank you very much.
Any sample piece of code wiich does so..?
I tried in net.. so far I wasn't sucessful..
Regards
Sathian
"Thomas" <thomas@.newsgroup.nospam> wrote in message
news:eoguWJXQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> No idea, but would you want to? T-SQL was not designed for this.
>
> Absolutely. It's a piece of cake. Remember that an image field is nothing
more
> than an array of bytes. All you do is creata a FileStream and set it's
contents
> to that of the byte array from the image field.
>
> Thomas
>|||Although this is not the forum for this sort of question...
private const string connStr = ...
public void ReadFromDBToFile(string destFilePath)
{
byte[] data = null;
using (SqlConnection conn = new SqlConnection(connStr))
{
StringBuilder sb = new StringBuilder();
sb.Append("Select Content, DataLength(Content) As Len");
sb.AppendFormat("\nFrom dbo.TableName");
sb.AppendFormat("\nWhere PK = @.PK");
conn.Open();
using (SqlCommand cmd = new SqlCommand(sb.ToString(), conn))
{
cmd.Parameters.Add("@.PK", SqlDbType...);
cmd.Parameters[0].Value = <pk>
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
int len = dr.GetInt32(1);
data = new byte[len];
dr.GetBytes(0, 0, data, 0, data.Length);
}
}
}
using (FileStream fs = new FileStream(destFilePath, FileMode.Create,
FileAccess.Write, FileShare.Write))
{
fs.Write(data, 0, data.Length);
}
}
public void WriteFromFileToDB(string sourceFilePath)
{
byte[] data;
using (FileStream fs = new FileStream(sourceFilePath, FileMode.Open,
FileAccess.Read, FileShare.Read))
{
data = new byte[fs.Length];
fs.Read(data, 0, (int)fs.Length);
}
using (SqlConnection conn = new SqlConnection(connStr))
{
StringBuilder sb = new StringBuilder();
sb.Append("Update dbo.TableName");
sb.AppendFormat("\nSet Content = @.Content");
sb.AppendFormat("\nWhere PK= @.PK");
conn.Open();
using (SqlCommand cmd = new SqlCommand(sb.ToString(), conn))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("@.Content", SqlDbType.Image);
cmd.Parameters.Add("@.PK", SqlDbType...
cmd.Parameters[0].Value = data;
cmd.Parameters[1].Value = <pk>
cmd.ExecuteNonQuery();
}
}
}
I used a dynamic SQL statement, but you could just as easily use a stored pr
oc.
HTH
Thomas
"Sathian" <sathian.t@.in.bosch.com> wrote in message
news:d3nfqc$oem$1@.ns2.fe.internet.bosch.com...
> Hello thomas,
> Thank you very much.
> Any sample piece of code wiich does so..?
> I tried in net.. so far I wasn't sucessful..
> Regards
> Sathian
> "Thomas" <thomas@.newsgroup.nospam> wrote in message
> news:eoguWJXQFHA.2876@.TK2MSFTNGP09.phx.gbl...
> more
> contents
>
Monday, March 19, 2012
Image control and DB
I wanna know how to retrieve & insert an image from/to a Sql Server database.
usingimage control or any other control
I've done that with windows formpicture box.
As that was explained in MS tutorials
Code….
--------------
Dim msAsNew MemoryStreamPictureBox1.Image.Save(ms, PictureBox1.Image.RawFormat)Dim arrImage()AsByte = ms.GetBufferms.Close()
Dim strSQLAsString = _ "INSERT INTO Emp (EmpName,EmpSalary,Picture)" & _ "VALUES (@.EmpName,@.EmpSalary,@.Picture)" Dim cmdAsNew SqlCommand(strSQL, ConnEmp) With cmd .Parameters.Add(New SqlParameter("@.Picture", _ SqlDbType.Image)).Value = arrImage .Parameters.Add(New SqlParameter("@.EmpName", _ SqlDbType.NVarChar)).Value = txtEmpName.Text .Parameters.Add(New SqlParameter("@.EmpSalary", _ SqlDbType.Decimal)).Value = txtEmpSalary.Text EndWithcmd.ExecuteNonQuery()
--------------
But with a web form'simage control IDO NOTknow how to do it
I real appreciate your help
Thank you
Here's an article on it:http://aspalliance.com/articleViewer.aspx?aId=140
Hope this helps...
-Damien
Monday, March 12, 2012
I'm gonna SHOOT the @#$% server!
Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual directory
using the SQLXML IIS utility and all is well. BUT... when I try connecting
to the web service via VS.NET, I keep getting this...
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: The virtual name could not be recognized
I even get that if I try browsing the WSDL file directly from IE.
Now I've checked the security, I've checked the configuration, I've checked
it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
Now the odd thing is if I disable the application on that virtual directory
(thus stopping the maaping through the DLL, I can properly browse the WSDL
file. HUH?
So... anyone got any ideas and if not, any bullets or a large mallet?
Mark
Please don't shoot.
I forwarded your problem to one of the people of the SQLXML team and hope he
will reply to you.
Best regards
Michael
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
|||Hi there,
Do you have the SOAP Toolkit 2.0 installed? SqlXml 3.0 SP2 requires it for
using web services. However, if you can wait a bit longer, we will be
releasing SP3 which removes that dependency so SOAP Toolkit is no longer
needed.
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual directory
using the SQLXML IIS utility and all is well. BUT... when I try connecting
to the web service via VS.NET, I keep getting this...
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: The virtual name could not be recognized
I even get that if I try browsing the WSDL file directly from IE.
Now I've checked the security, I've checked the configuration, I've checked
it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
Now the odd thing is if I disable the application on that virtual directory
(thus stopping the maaping through the DLL, I can properly browse the WSDL
file. HUH?
So... anyone got any ideas and if not, any bullets or a large mallet?
Mark
Please don't shoot.
I forwarded your problem to one of the people of the SQLXML team and hope he
will reply to you.
Best regards
Michael
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
|||Hi there,
Do you have the SOAP Toolkit 2.0 installed? SqlXml 3.0 SP2 requires it for
using web services. However, if you can wait a bit longer, we will be
releasing SP3 which removes that dependency so SOAP Toolkit is no longer
needed.
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
Im getting a Login failed... error when trying to open my database from my default.aspx.vb
Good morning,
When I start my browser and try to open my (SQL Server 2000) database, using the 'Integrated Windows Authentication' method, I get the following error msg:
[SqlException: Login failed for user 'MYDOMAIN\ASPNET'.].
Where DOMAIN = MYDOMAIN
and USER = ASPNET
I have made this user known to the SQL Server 2000...
I opened my browser and executed the following function, which is in my default.aspx.vb file:
Public Function checkuser(ByVal userName As String, ByVal password As String) As Boolean
Dim strConnection As String = _
"Data Source=localhost;Initial Catalog=dbo; Integrated Security=True"
Dim sqlconQCards As SqlConnection = New SqlConnection(strConnection)
sqlconQCards.Open()
End Function
Rather than opening the database, the error message, shown above, is displayed.
I'd appreciate any help.
Thanks,
PatDid you add the user in the database itself ?!
Rudy|||Hi Rudy,
I finally got it to work by changing to 'SQL Server Authentication'. It requres that the user/pswd be supplied.
The 'Integrated Windows Authentication', which does not require the user/pswd, is not working for me...This is the Microsoft recommended method...
I am using Microsoft SQL Server 2000...
Thanks,
Pat
Friday, March 9, 2012
IIS6 connect to sql server on another machine w/windows authentication
Can someone point me at an article that tells how to allow theASP.net worker process to connect, via windows authentication, to aremote sql server instance ?
Start with:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnpag2/html/PAGHT000008.asp
The remote server access is in the connection string, specifying server and instance.
Jeff
|||Also make sure remote connections enabled on the remote SQL instnace. Check this KB:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any clues
Hi
Maybe
http://support.microsoft.com/default...b;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=data
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/default.aspx?scid=kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS Virtual Directory for SQL
On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql sp4)
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
and sqlxml 3.0 SP3 installed.
On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
Management for SQL Server Utility to set up a virtual directory pointing to
the northwind db on Server A.
The following query works - but only with basic authenticatiohn -
http://serverA:8080/nwind?sql=select * from categories for xml auto&root=dat
a
With SQL authentication (same credentials) I get the following error:
Invalid connection settings: access denied
Any clues?
Thanks in advance
Any cluesHi
Maybe
http://support.microsoft.com/defaul...kb;en-us;820874
John
"drmcj" <drmcj@.discussions.microsoft.com> wrote in message
news:2AD2919F-18A8-4D41-9CFD-AB41485D557D@.microsoft.com...
> On a Windows 2000 Server (sp4) (Server A), I have SQL server 2000 (sql
> sp4)
> and sqlxml 3.0 SP3 installed.
> On a seperate Windows 2003 (Server B) server I used IIS Virtual Directory
> Management for SQL Server Utility to set up a virtual directory pointing
> to
> the northwind db on Server A.
> The following query works - but only with basic authenticatiohn -
> http://serverA:8080/nwind?sql=select * from categories for xml
> auto&root=data
> With SQL authentication (same credentials) I get the following error:
> Invalid connection settings: access denied
> Any clues?
> Thanks in advance
> Any clues
IIS version
How can I find out what version is my IIS Server (Windows 2000)?
Can I upgrade this version ?if you open IIS from the Administrative tools, you can see the version of your IIS in the help --> About Internet Information Services. For Windows 2000 this is standard version 5. Not sure if you can upgrade to a newer version.|||Originally posted by jora
if you open IIS from the Administrative tools, you can see the version of your IIS in the help --> About Internet Information Services. For Windows 2000 this is standard version 5. Not sure if you can upgrade to a newer version.
This might seem silly, but I don't think I have a 'About Internet Information Services' section in the help app of IIS. My computer is win2k so I assume I have v. 5.0, but I have Visual Studio 2003 (and hence .NET Framework 1.1) so it might be v. 6.0.
It says something about documentation being available at http://localhost/iisHelp/ but I just get a 'Page cannot be Found' error.
Any suggestions?
MNJ
Can I upgrade this version ?if you open IIS from the Administrative tools, you can see the version of your IIS in the help --> About Internet Information Services. For Windows 2000 this is standard version 5. Not sure if you can upgrade to a newer version.|||Originally posted by jora
if you open IIS from the Administrative tools, you can see the version of your IIS in the help --> About Internet Information Services. For Windows 2000 this is standard version 5. Not sure if you can upgrade to a newer version.
This might seem silly, but I don't think I have a 'About Internet Information Services' section in the help app of IIS. My computer is win2k so I assume I have v. 5.0, but I have Visual Studio 2003 (and hence .NET Framework 1.1) so it might be v. 6.0.
It says something about documentation being available at http://localhost/iisHelp/ but I just get a 'Page cannot be Found' error.
Any suggestions?
MNJ
IIS server set up for .net app
Hi,
I use windows authentication for .net app to connection to sql 2k server.
I got the following error --(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)
Connection string -- server=sql serv1;database=mydb;trusted_connection
= true
appserver = app1
Any ideas?
The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.
You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
|||Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.
If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.
Ekrem nsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
I use windows authentication for .net app to connection to sql 2k server.
I got the following error --(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)
Connection string -- server=sql serv1;database=mydb;trusted_connection
= true
appserver = app1
Any ideas?
The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.
You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
|||Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.
If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.
Ekrem nsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
IIS server set up for .net app
Hi,
I use windows authentication for .net app to connection to sql 2k server.
I got the following error --(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)
Connection string -- server=sql serv1;database=mydb;trusted_connection
= true
appserver = app1
Any ideas?The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.
You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>|||Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.
If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.
Ekrem nsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
I use windows authentication for .net app to connection to sql 2k server.
I got the following error --(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)
Connection string -- server=sql serv1;database=mydb;trusted_connection
= true
appserver = app1
Any ideas?The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.
You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>|||Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.
If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.
Ekrem nsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
IIS server set up for .net app
Hi,
I use windows authentication for .net app to connection to sql 2k server.
I got the following error --(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)
Connection string -- server=sql serv1;database=mydb;trusted_connection
= true
appserver = app1
Any ideas?The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.
You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>|||Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.
If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.
--
Ekrem Önsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
I use windows authentication for .net app to connection to sql 2k server.
I got the following error --(Login failed for user '(null)'. Reason: Not
associated with a trusted SQL Server connection)
Connection string -- server=sql serv1;database=mydb;trusted_connection
= true
appserver = app1
Any ideas?The idea is that the windows user account used to run your application
(Window Form app or ASP.NET app?) does not have a mapped SQL Server login
created in the SQL Server, thus cannot log into SQL Server.
You need to create a SQL Server login that mapps to that windows user
account or a Windows user security group, which includes that user account
as member. Then you need to add this SQL Server login to target database as
user, then assign appropriate permissions.
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>|||Ensure that the Windows Account that you work your app under is added to the
domain and it has a valid Login in your SQL Server.
If the Windows user account is not in your domain and you use Trusted
Connections then you get this error.
--
Ekrem Önsoy
"mecn" <mecn2002@.yahoo.com> wrote in message
news:%23ygmjY3OIHA.6036@.TK2MSFTNGP03.phx.gbl...
> Hi,
> I use windows authentication for .net app to connection to sql 2k server.
> I got the following error --(Login failed for user '(null)'. Reason: Not
> associated with a trusted SQL Server connection)
> Connection string -- server=sql
> serv1;database=mydb;trusted_connection = true
> appserver = app1
> Any ideas?
>
Subscribe to:
Posts (Atom)