About accessing data from sqlserver

Hello sir,
I have installed .net1.1version on windows2003 operating system.I have also installed sqlserver2000 on the same system.
My problem is that when i am trying to get data from sqlserver from asp.net program i am getting error as
'access denied to user NT AUTHORITY/NETWORK USER'.
I request you to kindly suggest me with an appropriate solution.
Thanking you.
Please email meon:-aanandkumar786@.yahoo.comeither the account that asp.net uses to run pages needs to be given access to the database, or you need to create your sql connection string with a specific sql server account to allow for the authentication.

about 32 bit application and odbc to access 64 bit SQL Server 2005

Hello
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
Lionel
No, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:

> Hello
> Our application currently is running on IIS machine with Windows 2003 32 bit
> OS installed and database server machine with Windows 2000 32 bit OS and SQL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS and
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel
|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...[vbcol=seagreen]
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:

about 32 bit application and odbc to access 64 bit SQL Server 2005

Hello
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
LionelNo, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:

> Hello
> Our application currently is running on IIS machine with Windows 2003 32 b
it
> OS installed and database server machine with Windows 2000 32 bit OS and S
QL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS a
nd
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.c...1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...[vbcol=seagreen]
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
>

about 32 bit application and odbc to access 64 bit SQL Server 2005

Hello
Our application currently is running on IIS machine with Windows 2003 32 bit
OS installed and database server machine with Windows 2000 32 bit OS and SQL
server 2000 installed.
We are thinking to upgrade the database server to Windows 2003 64 bit OS and
SQL server 2005 64 bit.
The IIS machine is still on 32 bit OS and application, We are wondering if
there is any problem for 32 bit application and ODBC to access the 64 bit
database?
Thanks in advance
LionelNo, there is no problem. I least I have seen dozens of similar applications
accesing 64-bit databases.
Most of the connectivity issues I have seen is connecting SQL Server 64-bit
to Oracle but there is always a solution.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"lionel" wrote:
> Hello
> Our application currently is running on IIS machine with Windows 2003 32 bit
> OS installed and database server machine with Windows 2000 32 bit OS and SQL
> server 2000 installed.
> We are thinking to upgrade the database server to Windows 2003 64 bit OS and
> SQL server 2005 64 bit.
> The IIS machine is still on 32 bit OS and application, We are wondering if
> there is any problem for 32 bit application and ODBC to access the 64 bit
> database?
> Thanks in advance
> Lionel|||Lionel,
Here is a nice article on migrating to 64 bit SQL Server and the drivers it
takes to connect.
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1241693,00.html
The only issue when using a 64 bit OS that I have noticed is on the Jet
(Access) connector which doesnt exist on 64 bit.
--
/*
Warren Brunk - MCITP,MCTS,MCDBA
www.techintsolutions.com
*/
"Ben Nevarez" <BenNevarez@.discussions.microsoft.com> wrote in message
news:EF862D05-83A0-4F45-A0DE-D12F696E7EE8@.microsoft.com...
> No, there is no problem. I least I have seen dozens of similar
> applications
> accesing 64-bit databases.
> Most of the connectivity issues I have seen is connecting SQL Server
> 64-bit
> to Oracle but there is always a solution.
> Hope this helps,
> Ben Nevarez
> Senior Database Administrator
> AIG SunAmerica
>
> "lionel" wrote:
>> Hello
>> Our application currently is running on IIS machine with Windows 2003 32
>> bit
>> OS installed and database server machine with Windows 2000 32 bit OS and
>> SQL
>> server 2000 installed.
>> We are thinking to upgrade the database server to Windows 2003 64 bit OS
>> and
>> SQL server 2005 64 bit.
>> The IIS machine is still on 32 bit OS and application, We are wondering
>> if
>> there is any problem for 32 bit application and ODBC to access the 64 bit
>> database?
>> Thanks in advance
>> Lionel

Ability to schedule job across Domains

Situation: I have to copy data from a host SQL Server and place it onto my
SQL Server. We have an intermediary box with Console installed with both SQL
Servers registered. I have setup a DTS that performs the transfer.
Problem: I can run the DTS manually but when I schedule the job to run
automatically I get an error message that the job cannot be run because the
user is a nonSysAdmin.
That is because the context of the package is different when you run it as a
job, instead of you running it. See if this helps:
http://support.microsoft.com/default...269074&sd=tech
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:D1FAB676-20A5-4DE1-A20E-90C5114A10BB@.microsoft.com...
Situation: I have to copy data from a host SQL Server and place it onto my
SQL Server. We have an intermediary box with Console installed with both
SQL
Servers registered. I have setup a DTS that performs the transfer.
Problem: I can run the DTS manually but when I schedule the job to run
automatically I get an error message that the job cannot be run because the
user is a nonSysAdmin.
|||Since the 1st box is accessed thru VPN, we have a 2nd box that acts as the
connecting device with console and is outside our domain, and the 3rd box is
inside our domain with SQL installed. I made the login, for test purposes a
member of sysadmin. This allowed me to schedule the job and it would run as
scheduled but now I get a message that it cannot find the server referenced
(a simply sql statement is my test to the 1st box).
Here is what the job history tells me:
Executed as user: TEST1\SYSTEM. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError:
DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error
string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 Error Detail Records: Error:
-2147467259 (80004005); Provider Error: 17 (11) Error string:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
Thanks a bunch for you help on this.
"Narayana Vyas Kondreddi" wrote:

> That is because the context of the package is different when you run it as a
> job, instead of you running it. See if this helps:
> http://support.microsoft.com/default...269074&sd=tech
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:D1FAB676-20A5-4DE1-A20E-90C5114A10BB@.microsoft.com...
> Situation: I have to copy data from a host SQL Server and place it onto my
> SQL Server. We have an intermediary box with Console installed with both
> SQL
> Servers registered. I have setup a DTS that performs the transfer.
> Problem: I can run the DTS manually but when I schedule the job to run
> automatically I get an error message that the job cannot be run because the
> user is a nonSysAdmin.
>
>

Ability to schedule job across Domains

Situation: I have to copy data from a host SQL Server and place it onto my
SQL Server. We have an intermediary box with Console installed with both SQ
L
Servers registered. I have setup a DTS that performs the transfer.
Problem: I can run the DTS manually but when I schedule the job to run
automatically I get an error message that the job cannot be run because the
user is a nonSysAdmin.That is because the context of the package is different when you run it as a
job, instead of you running it. See if this helps:
http://support.microsoft.com/defaul...;269074&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:D1FAB676-20A5-4DE1-A20E-90C5114A10BB@.microsoft.com...
Situation: I have to copy data from a host SQL Server and place it onto my
SQL Server. We have an intermediary box with Console installed with both
SQL
Servers registered. I have setup a DTS that performs the transfer.
Problem: I can run the DTS manually but when I schedule the job to run
automatically I get an error message that the job cannot be run because the
user is a nonSysAdmin.|||Since the 1st box is accessed thru VPN, we have a 2nd box that acts as the
connecting device with console and is outside our domain, and the 3rd box is
inside our domain with SQL installed. I made the login, for test purposes a
member of sysadmin. This allowed me to schedule the job and it would run as
scheduled but now I get a message that it cannot find the server referenced
(a simply sql statement is my test to the 1st box).
Here is what the job history tells me:
Executed as user: TEST1\SYSTEM. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError:
DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error
string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or
access denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 Error Detail Records: Error:
-2147467259 (80004005); Provider Error: 17 (11) Error string:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
Thanks a bunch for you help on this.
"Narayana Vyas Kondreddi" wrote:

> That is because the context of the package is different when you run it as
a
> job, instead of you running it. See if this helps:
> http://support.microsoft.com/defaul...;269074&sd=tech
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:D1FAB676-20A5-4DE1-A20E-90C5114A10BB@.microsoft.com...
> Situation: I have to copy data from a host SQL Server and place it onto my
> SQL Server. We have an intermediary box with Console installed with both
> SQL
> Servers registered. I have setup a DTS that performs the transfer.
> Problem: I can run the DTS manually but when I schedule the job to run
> automatically I get an error message that the job cannot be run because th
e
> user is a nonSysAdmin.
>
>

Ability to schedule job across Domains

Situation: I have to copy data from a host SQL Server and place it onto my
SQL Server. We have an intermediary box with Console installed with both SQL
Servers registered. I have setup a DTS that performs the transfer.
Problem: I can run the DTS manually but when I schedule the job to run
automatically I get an error message that the job cannot be run because the
user is a nonSysAdmin.That is because the context of the package is different when you run it as a
job, instead of you running it. See if this helps:
http://support.microsoft.com/default.aspx?scid=kb;en-us;269074&sd=tech
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
news:D1FAB676-20A5-4DE1-A20E-90C5114A10BB@.microsoft.com...
Situation: I have to copy data from a host SQL Server and place it onto my
SQL Server. We have an intermediary box with Console installed with both
SQL
Servers registered. I have setup a DTS that performs the transfer.
Problem: I can run the DTS manually but when I schedule the job to run
automatically I get an error message that the job cannot be run because the
user is a nonSysAdmin.|||Since the 1st box is accessed thru VPN, we have a 2nd box that acts as the
connecting device with console and is outside our domain, and the 3rd box is
inside our domain with SQL installed. I made the login, for test purposes a
member of sysadmin. This allowed me to schedule the job and it would run as
scheduled but now I get a message that it cannot find the server referenced
(a simply sql statement is my test to the 1st box).
Here is what the job history tells me:
Executed as user: TEST1\SYSTEM. DTSRun: Loading... DTSRun: Executing...
DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnError:
DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error
string: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 Error Detail Records: Error:
-2147467259 (80004005); Provider Error: 17 (11) Error string:
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied. Error source: Microsoft OLE DB Provider for SQL Server
Help file: Help context: 0 DTSRun OnFinish:
DTSStep_DTSExecuteSQLTask_1 DTSRun: Package execution complete. Process
Exit Code 1. The step failed.
Thanks a bunch for you help on this.
"Narayana Vyas Kondreddi" wrote:
> That is because the context of the package is different when you run it as a
> job, instead of you running it. See if this helps:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;269074&sd=tech
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "bssolutions" <bssolutions@.discussions.microsoft.com> wrote in message
> news:D1FAB676-20A5-4DE1-A20E-90C5114A10BB@.microsoft.com...
> Situation: I have to copy data from a host SQL Server and place it onto my
> SQL Server. We have an intermediary box with Console installed with both
> SQL
> Servers registered. I have setup a DTS that performs the transfer.
> Problem: I can run the DTS manually but when I schedule the job to run
> automatically I get an error message that the job cannot be run because the
> user is a nonSysAdmin.
>
>

a user can't be deleted...

Hi,
I've just installed SQL Server 2005, and mistakenly add a user in
ServerName\Database\master; I added two kind of schema into that user.
But when I tried to delete the user, SQL Server 2005 tells me that database
user have schema assigned to it thus can't be remove.
Is there a way to do delete it?
PS: I have another serious problem regarding SQL Server 2005 database,
please take a look at it in "SQL Server Server newsgroup" under "failed to
connect to SQL Server's database!" thread. Any suggestions and help is
greatly appreciated.
Thank you.You have to first remove the schemas assigned to the user BEFORE you can
remove the user.
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
"Dhow" <Dhow@.discussions.microsoft.com> wrote in message
news:958F2A86-5F41-41B6-92E8-9AB888FCD441@.microsoft.com...
> Hi,
> I've just installed SQL Server 2005, and mistakenly add a user in
> ServerName\Database\master; I added two kind of schema into that user.
> But when I tried to delete the user, SQL Server 2005 tells me that
> database
> user have schema assigned to it thus can't be remove.
> Is there a way to do delete it?
> PS: I have another serious problem regarding SQL Server 2005 database,
> please take a look at it in "SQL Server Server newsgroup" under "failed to
> connect to SQL Server's database!" thread. Any suggestions and help is
> greatly appreciated.
> Thank you.

A third dynamic assembly loading problem ;)

Hi!

From the dll I've installed in SQL Server I load a dll via reflection.assembly.load from the GAC . I know the dll can load the dll when I test it outside SQL Server but when I run it via a store procedure from within the SQL Server I keep getting a System.IO.FileNotFoundException.

How does this work? Isn't all dll in the GAC loaded by SQL Server? Is this impossible to achieve?

Thanks in advance

Richard Hallgren

There are only a sub-set (13 or something like that, all of them system assemblies) of assemblies that are allowed to leaded from the GAC inside of SQL Server. No user assemblies are allowed to be loaded from the GAC.

So what you need to do is to catalog the assemblies you want to load dynamically in the database, and it should work.

Niels
|||Thanks Niels!

But the dependency tree for the assemblies I like to reference is kind of big and guess I have to catalog all of those as well (that is the assemblies that the assembly I like to reference depend on). Some of them contains unmanaged code as well but I guess as long as I set the unsafe permission mode on those I should be able to catalog those as well. Right?|||

Richard Hallgren wrote:

But the dependency tree for the assemblies I like to reference is kind of big and guess I have to catalog all of those as well (that is the assemblies that the assembly I like to reference depend on). Some of them contains unmanaged code as well but I guess as long as I set the unsafe permission mode on those I should be able to catalog those as well. Right?

You basically need to catalog all assemblies that will be loaded, either directly or indirectly.

Niels

A stupid SQL RS question

Hello everyone,
I am newbie to SQL RS and just got it installed on my laptop. I wanted
to know if the following is possible with SQL RS or do I need to use a thrid
party tool. Here is what I want to do:
I have a search website where users can query certain (SQL) databases
and generate reports. Currently the reports are in HTML format and I using
ASP.NET to do all the searching and report displaying.
Is it possible to provide a report save option which will convert the
generated report into PDF/EXCEL/TEXT/etc? Can I make use of SQL RS or do I
have to use a thrid party software like ASP2PDF'
thank you all in advance,
BIYou have multiple options for rendering formats. See
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPORTAL/HTM/rs_gts_portal_3vqd.asp
--
-- John H. Miller [MSFT]
-- SQL Server BI Product Group
----
--
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
----
--
"bhai" <bhai@.vt.edu> wrote in message
news:e3asQNadEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> I am newbie to SQL RS and just got it installed on my laptop. I wanted
> to know if the following is possible with SQL RS or do I need to use a
thrid
> party tool. Here is what I want to do:
> I have a search website where users can query certain (SQL) databases
> and generate reports. Currently the reports are in HTML format and I using
> ASP.NET to do all the searching and report displaying.
> Is it possible to provide a report save option which will convert the
> generated report into PDF/EXCEL/TEXT/etc? Can I make use of SQL RS or do
I
> have to use a thrid party software like ASP2PDF'
> thank you all in advance,
> BI
>|||Use the Reporting Services Web Service (SOAP API) for programmatic exporting
of reports. The method you want is "Render".
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"bhai" <bhai@.vt.edu> wrote in message
news:e3asQNadEHA.3512@.TK2MSFTNGP12.phx.gbl...
> Hello everyone,
> I am newbie to SQL RS and just got it installed on my laptop. I wanted
> to know if the following is possible with SQL RS or do I need to use a
thrid
> party tool. Here is what I want to do:
> I have a search website where users can query certain (SQL) databases
> and generate reports. Currently the reports are in HTML format and I using
> ASP.NET to do all the searching and report displaying.
> Is it possible to provide a report save option which will convert the
> generated report into PDF/EXCEL/TEXT/etc? Can I make use of SQL RS or do
I
> have to use a thrid party software like ASP2PDF'
> thank you all in advance,
> BI
>

A simple Problem with XDR and xsd

Hi,
i am using sql server 2000 SP 4 and i had also installed SQLXML 3.0 SP 2
i had some XSD in my virtual directory when i query my xsd then for simle xsd
which are based on a single table it works fine as show below
<?xml version="1.0" encoding="utf-8" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:element name="Customers" sql:relation="Customers">
<xsd:complexType>
<sequence>
<xsd:attribute name="CustomerID" sql:field="CustomerID" type="xsd:
string"/>
<xsd:attribute name="CompanyName" sql:field="CompanyName" type="xsd:
string"/>
<xsd:attribute name="ContactName" sql:field="ContactName" type="xsd:
string"/>
</sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>
but when my xsd conatins multiple table it same cannot open the page the
problem i am facing with my xdr the xdr below does not works
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:sql="urn:schemas-microsoft-com:mapping-schema">
<xsd:element name="CustomerRecord" sql:relation="Customers" >
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Contact" sql:field="ContactName"
type="xsd:string" />
<xsd:element name="Title" sql:field="ContactTitle" type="xsd:
string" />
<xsd:element name="Company" sql:field="CompanyName"
type="xsd:string" />
<xsd:element ref="Order" sql:relationship="CustomerOrder" />
</xsd:sequence>
<xsd:attribute name="ID" sql:field="CustomerID" type="xsd:
string" />
</xsd:complexType>
</xsd:element>
<xsd:element name="Order" sql:relation="Orders" >
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="Items" sql:relationship="OrderOrderDetails"
/>
</xsd:sequence>
<xsd:attribute name="OrderID" type="xsd:int"/>
<xsd:attribute name="Ordered" sql:field="OrderDate" type="xsd:
dateTime"/>
<xsd:attribute name="Shipped" sql:field="ShippedDate" type="xsd:
dateTime"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="Items" sql:relation="[Order Details]" >
<xsd:complexType>
<xsd:sequence>
<xsd:element ref="ItemPurchased"
sql:relationship="OrderDetailsProducts" />
</xsd:sequence>
<xsd:attribute name="Price" sql:field="UnitPrice" type="xsd:
int"/>
<xsd:attribute name="Quantity" type="xsd:int"/>
</xsd:complexType>
</xsd:element>
<xsd:element name="ItemPurchased" type="Products" sql:relation="Products"
/>
<xsd:complexType name="Products">
<xsd:sequence>
<xsd:element name="Name" sql:field="ProductName" type="xsd:
string" />
<xsd:element name="NumberInStock" sql:field="UnitsInStock"
type="xsd:int" />
</xsd:sequence>
</xsd:complexType>
<xsd:annotation>
<xsd:appinfo>
<sql:relationship name="CustomerOrder"
parent="Customers"
parent-key="CustomerID"
child="Orders"
child-key="CustomerID" />
<sql:relationship name="OrderOrderDetails"
parent="Orders"
parent-key="OrderID"
child="[Order Details]"
child-key="OrderID" />
<sql:relationship name="OrderDetailsProducts"
parent="[Order Details]"
parent-key="ProductID"
child="Products"
child-key="ProductID" />
</xsd:appinfo>
</xsd:annotation>
</xsd:schema>
Thanks in advance
vinod nauriyal
Hi,
Could you please provide more details on why it doesn't work?
What error do you get?
Thanks,
Monica Frintu
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
|||Hi Monica,
Thanks for you response .When i search the log it is giving me
Object_not_a_collection kind of error .
stype=www&vtype=vdir&title=IISAdmin&spath=&dpath=I IS%
3A//localhost/W3SVC/2/ROOT/IISAdmin|17|800a01c3|Object_not_a_collection 500
Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)
2005-06-20 14:51:43 127.0.0.1 IN002\ic002260 127.0.0.1 6198 GET /iistat.asp
thisState= 200 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)
Even in my simple XSD if i include the tag <SEQUENCE> it gives me this error
Regards
Vinod Nauriyal
Message posted via http://www.droptable.com
|||This doesn't look like an error from SQLXML. Could you be more precise about
your steps? For example:
- Your IIS and SqlXml virtual directory configuration/
- The query executed.
Thanks.
Bertan ARI
This posting is provided "AS IS" with no warranties, and confers no rights.
"vinod nauriyal via droptable.com" <forum@.droptable.com> wrote in message
news:502AABA931FA0@.droptable.com...
> Hi Monica,
> Thanks for you response .When i search the log it is giving me
> Object_not_a_collection kind of error .
> stype=www&vtype=vdir&title=IISAdmin&spath=&dpath=I IS%
> 3A//localhost/W3SVC/2/ROOT/IISAdmin|17|800a01c3|Object_not_a_collection
> 500
> Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)
> 2005-06-20 14:51:43 127.0.0.1 IN002\ic002260 127.0.0.1 6198 GET
> /iistat.asp
> thisState= 200 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)
> Even in my simple XSD if i include the tag <SEQUENCE> it gives me this
> error
> Regards
> Vinod Nauriyal
> --
> Message posted via http://www.droptable.com

a server with this name already exists?

Hi SQL Guru's
I have installed sql server 2000 on a new server. Our old server was called
SQL01 and I installed the new server as SQL01 as well (but just not on the
network to avoid the name clash)
I have now removed the old SQL01 server, put the new one in and changed the
IP Address so everything is the same as the old one. When I open EM on the
server itself and try and register it as SQL01 (it is currently local) I get
the error meesage "A Server with this name already exists" and I cannot
register the server.
I can connect to it remotly fine and setup my remote EM with the name SQL01
without any problems, but as soon as I try on the server I get that error.
Firstly does anyone know how to resolve this. I think the new server has
somehow learned about the old one and has remembered it so it won't let me
add this one with the same name. I have tried rebooting it and still does
this, so it's like it's cached the setting somewher and I need to remove
that so I can regoster it correctly.
Thanks for any help.
Teddy
Look at sp_addserver and sp_dropserver stored procedures in the BOL
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>
|||A server name can only be registered once in SEM... Delete the other server
registration, THEN add the new registration...( I mean delete the LOCAL
registration first.)
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
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>

a server with this name already exists?

Hi SQL Guru's
I have installed sql server 2000 on a new server. Our old server was called
SQL01 and I installed the new server as SQL01 as well (but just not on the
network to avoid the name clash)
I have now removed the old SQL01 server, put the new one in and changed the
IP Address so everything is the same as the old one. When I open EM on the
server itself and try and register it as SQL01 (it is currently local) I get
the error meesage "A Server with this name already exists" and I cannot
register the server.
I can connect to it remotly fine and setup my remote EM with the name SQL01
without any problems, but as soon as I try on the server I get that error.
Firstly does anyone know how to resolve this. I think the new server has
somehow learned about the old one and has remembered it so it won't let me
add this one with the same name. I have tried rebooting it and still does
this, so it's like it's cached the setting somewher and I need to remove
that so I can regoster it correctly.
Thanks for any help.Teddy
Look at sp_addserver and sp_dropserver stored procedures in the BOL
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>|||A server name can only be registered once in SEM... Delete the other server
registration, THEN add the new registration...( I mean delete the LOCAL
registration first.)
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
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>

a server with this name already exists?

Hi SQL Guru's
I have installed sql server 2000 on a new server. Our old server was called
SQL01 and I installed the new server as SQL01 as well (but just not on the
network to avoid the name clash)
I have now removed the old SQL01 server, put the new one in and changed the
IP Address so everything is the same as the old one. When I open EM on the
server itself and try and register it as SQL01 (it is currently local) I get
the error meesage "A Server with this name already exists" and I cannot
register the server.
I can connect to it remotly fine and setup my remote EM with the name SQL01
without any problems, but as soon as I try on the server I get that error.
Firstly does anyone know how to resolve this. I think the new server has
somehow learned about the old one and has remembered it so it won't let me
add this one with the same name. I have tried rebooting it and still does
this, so it's like it's cached the setting somewher and I need to remove
that so I can regoster it correctly.
Thanks for any help.Teddy
Look at sp_addserver and sp_dropserver stored procedures in the BOL
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>|||A server name can only be registered once in SEM... Delete the other server
registration, THEN add the new registration...( I mean delete the LOCAL
registration first.)
--
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
"Teddy Smith" <teddy@.smith.com> wrote in message
news:ce2b2s$c3h$1@.pinah.connect.com.au...
> Hi SQL Guru's
> I have installed sql server 2000 on a new server. Our old server was
called
> SQL01 and I installed the new server as SQL01 as well (but just not on the
> network to avoid the name clash)
> I have now removed the old SQL01 server, put the new one in and changed
the
> IP Address so everything is the same as the old one. When I open EM on the
> server itself and try and register it as SQL01 (it is currently local) I
get
> the error meesage "A Server with this name already exists" and I cannot
> register the server.
> I can connect to it remotly fine and setup my remote EM with the name
SQL01
> without any problems, but as soon as I try on the server I get that error.
> Firstly does anyone know how to resolve this. I think the new server has
> somehow learned about the old one and has remembered it so it won't let me
> add this one with the same name. I have tried rebooting it and still does
> this, so it's like it's cached the setting somewher and I need to remove
> that so I can regoster it correctly.
> Thanks for any help.
>

A problem with connecting to a Oct. CTP server

Hi, folks
I think I need a little help here. I uninstall the beta2 version and installed Oct. CTP. The server was using named-instance so I took it as it was. Installatoin went fine and attached privious databases in SQL Management Studio. That means, I am able to sign on the SQL server in the same box using SQL Management Studio. However, from developers (I believe it's beta2 version) could not register this server (my-dev02\sql2005) on their SQL Management Studio.

The error is
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (.Net SqlClient Data Provider)

I tried from another server (signed on as Domain Admin) using Windows Auth. I got same error msg. IPAddress is enabled, TCP/IP also enabled... Could not think of any more setting. Appreciate in advance.

SunnyFound a trick that is turn SQL Browser service on. Some how it disabled.|||As you found out, as a result of the security considerations, it's off by default for certain SKUs.

A problem with Adventure Works DW sample

Hi All,

I have downloaded and installed AdventureWorksDBCI.msi
but there is not instawdb.sql scrip. When I try to run a sample
it says:
Error 1 Database 'Adventure Works DW' :

I have checked in MSSQL Management Studio but the Adventure Works
does not exist there.

Which steps I need to do to install the Adventure Works DW'.

Thanks

Sergiy

Sergiy,

If I recall, after running the AdventureWorksDBCI.msi, you need to ATTACH the database. It 'should' be in the default datafile location.

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

I setup the Reporting Services Integration (Manage integration settings). I use the default SQL instance, I put the USERNAME and the PASSWORD of my ADMIN account in the ENTER CREDENTIALS windows.. When I click the "OK" button, I receive always the error ...

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

I am also having this same issue. I cannot seem to find any help for this out there by Google search or otherwise. I've seen some blip about installing on a domain controller. Please help.|||I discovered a workaround. I used the IP address of the DBMS instead of the local computer name. Then I used the DOMAINNAME\SP_Setup_User (or admin) account and password. This worked. Hopefully no ill effects.|||

Unfortunately, this approach didn't work for me. If any other idea, please let me know.

Thanks

|||

Erik,

I came to the conclusion to use the IP address of the SQL Server instead of the name because, you know how you want to map a drive to the same server using two different user accounts? Well, you have to use the server name for one mapping and then something else for the second mapping, like the IP address. It probably has nothing to do with this problem, but it reminded me of it. So it did work, at least on my system. Again, I do not know if there are any obscure consequences of doing this. So far all is well. Maybe there is a Microsoft person listening in or someone who could lend some thoughts to the situation for you.

Mike

|||

Hi Guys, had the same problem. Tried with IP address and yes it worked. However, when I went into Visual Studio and created a report when I went to deploy it a username/password form pops up. No matter what username/password is inserted can't get it to deploy. Any help would be greatly appreciated.

Keith

|||

Try using Fully Qualified domain Name of the SQL Server..

and It Works!..

|||

do you mean servername\username & password because it did not work. I enterede servername/username in the reporting services UI and then went into visual studio to deploy (on same machine) but when I went to deploy you would enter servername/username and it would just keep poping up and never do anything.

Any thing to look at for the account. I have tried a user account and on last atempt I used administrator, but no luck.

Thanks for any help!

|||

I have done some more work on it and in sharepoint central administration, reporting services, manage integration services, set to windows account. and it all saves with out complaing. Now when I gointo Visual studio on the same machine as reporting service and sharepoint I no longer get a log in box but I get "a connection could not be made to the report server... this operation is not supported on a report server that is configured to run in sharepoint integration...

anybody and thoughts?

Thanks

|||

did some more work/investigation and I stumbled into that if you go the sharepoint site, document library and try to add the new document type of reporting services, it does not show up in the list. So I think everything deployed okay but it appears there is no link between sharepoint and report services. Also incase this helps, sharepoint is not in the default website, but is it's own web site that instead of www we have companyweb. Other that reporting services sharpoint works fine.

Help!

|||

Keith,

Our report server web service is at http://{Report Server servername}:8080/ReportServer2K5, port 8080 being the new port of the re-enabled IIS default web site. However, the deployment properties for the VS 2005 report project actually had to be set like so: (1) TargetDataSourceFolder and TargetReportFolder = http://{SharePoint servername}:{Admin Site Port Number}/{Our Report Library Name}/, and (2) TargetServerURL = http://{SharePoint servername}:{Admin Site Port Number}/. I can deploy right from Visual Studio with this configuration. The account used for the Windows service identity is the same as that used for SharePoint administration in my case. There are a myriad of possible combinations for these accounts, though.

Mike

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

I setup the Reporting Services Integration (Manage integration settings). I use the default SQL instance, I put the USERNAME and the PASSWORD of my ADMIN account in the ENTER CREDENTIALS windows.. When I click the "OK" button, I receive always the error ...

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

I am also having this same issue. I cannot seem to find any help for this out there by Google search or otherwise. I've seen some blip about installing on a domain controller. Please help.|||I discovered a workaround. I used the IP address of the DBMS instead of the local computer name. Then I used the DOMAINNAME\SP_Setup_User (or admin) account and password. This worked. Hopefully no ill effects.|||

Unfortunately, this approach didn't work for me. If any other idea, please let me know.

Thanks

|||

Erik,

I came to the conclusion to use the IP address of the SQL Server instead of the name because, you know how you want to map a drive to the same server using two different user accounts? Well, you have to use the server name for one mapping and then something else for the second mapping, like the IP address. It probably has nothing to do with this problem, but it reminded me of it. So it did work, at least on my system. Again, I do not know if there are any obscure consequences of doing this. So far all is well. Maybe there is a Microsoft person listening in or someone who could lend some thoughts to the situation for you.

Mike

|||

Hi Guys, had the same problem. Tried with IP address and yes it worked. However, when I went into Visual Studio and created a report when I went to deploy it a username/password form pops up. No matter what username/password is inserted can't get it to deploy. Any help would be greatly appreciated.

Keith

|||

Try using Fully Qualified domain Name of the SQL Server..

and It Works!..

|||

do you mean servername\username & password because it did not work. I enterede servername/username in the reporting services UI and then went into visual studio to deploy (on same machine) but when I went to deploy you would enter servername/username and it would just keep poping up and never do anything.

Any thing to look at for the account. I have tried a user account and on last atempt I used administrator, but no luck.

Thanks for any help!

|||

I have done some more work on it and in sharepoint central administration, reporting services, manage integration services, set to windows account. and it all saves with out complaing. Now when I gointo Visual studio on the same machine as reporting service and sharepoint I no longer get a log in box but I get "a connection could not be made to the report server... this operation is not supported on a report server that is configured to run in sharepoint integration...

anybody and thoughts?

Thanks

|||

did some more work/investigation and I stumbled into that if you go the sharepoint site, document library and try to add the new document type of reporting services, it does not show up in the list. So I think everything deployed okay but it appears there is no link between sharepoint and report services. Also incase this helps, sharepoint is not in the default website, but is it's own web site that instead of www we have companyweb. Other that reporting services sharpoint works fine.

Help!

|||

Keith,

Our report server web service is at http://{Report Server servername}:8080/ReportServer2K5, port 8080 being the new port of the re-enabled IIS default web site. However, the deployment properties for the VS 2005 report project actually had to be set like so: (1) TargetDataSourceFolder and TargetReportFolder = http://{SharePoint servername}:{Admin Site Port Number}/{Our Report Library Name}/, and (2) TargetServerURL = http://{SharePoint servername}:{Admin Site Port Number}/. I can deploy right from Visual Studio with this configuration. The account used for the Windows service identity is the same as that used for SharePoint administration in my case. There are a myriad of possible combinations for these accounts, though.

Mike

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

I setup the Reporting Services Integration (Manage integration settings). I use the default SQL instance, I put the USERNAME and the PASSWORD of my ADMIN account in the ENTER CREDENTIALS windows.. When I click the "OK" button, I receive always the error ...

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Hi Did anyone have a resolution to this situation. We're getting the same error message following the same sequence of events. Any assistance is appreciated.

|||

No... nothing... niet...

If you find any info, let me know please.

|||

Anybody find anything on this? I'm getting same error|||

I'm getting the same frustrating error. Any news on a solution?

Thanks!

A new member could not be added to a local group because the member has the wrong account type

Hi all,

I installed SQL 2005 SP2 + ReportServices Add-in for Sharepoint (WSS 3.0). All it's OK until I try to grant database access in the Sharepoint Central Admin site.

I setup the Reporting Services Integration (Manage integration settings). I use the default SQL instance, I put the USERNAME and the PASSWORD of my ADMIN account in the ENTER CREDENTIALS windows.. When I click the "OK" button, I receive always the error ...

"A new member could not be added to a local group because the member has the wrong account type"

I tried a lot of things... without success.

Is there someone who can help me....

PS: There is no error in the LOG

Thanks

Hi Did anyone have a resolution to this situation. We're getting the same error message following the same sequence of events. Any assistance is appreciated.

|||

No... nothing... niet...

If you find any info, let me know please.

|||

Anybody find anything on this? I'm getting same error|||

I'm getting the same frustrating error. Any news on a solution?

Thanks!