Access database problem

Hi, I have problem connecting SQL2000 database.

I have installed .NetFramework 1.1 before and I got (local)\NetSDK instance name. I can connect any database under without any problem. However, I recently installed another database "Costoco" into the same instance from a bak file. And I try to connect it but it fails. I run a webapplication and use datagrid to show a table and the error message is following:

Cannot open database requested in login 'Costoco'. Login fails. Login failed for user 'AARON-HOME\ASPNET'

I checked ASPNET user and I even add this user to access the whole folder of the instance in Program files/SQLserver, it still happens.

I have no idea, and could any one help me?

Thanks.

It seems that the login have not been granted access to the new database. Please click 'Start'->'All Programs'->'Microsoft SQL Server'->'Enterprise Manager'. In EM, choose the 'NetSDK'instance, explore Security->Logins, find the login used in your application, double click it. In the Properties window, goto Data Access pannel, make sure the check box of the new database selected. Click 'ok' to save your change, then try again.|||Thanks a lot, It works!!!

Access a report from the Internet with no authentication

Is it possible to access a report from the Internet (in a non Windows Domain
context) without supplying any credentials. For instance, a user types in
this URL:
http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
and he/she woulnd not be prompted by a login dialog, and could simply view
the report.
I tried all sorts of different things (stored credentials in the datasource,
impersonating a user, etc.) from both BIDS and Report Manager, but I can't
seem to make it work. BTW, I can read the report just fine if I supply a
user name and password.
Thank you,
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comOn Dec 1, 4:12 pm, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
> Is it possible to access a report from the Internet (in a non Windows Domain
> context) without supplying any credentials. For instance, a user types in
> this URL:http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFol...
> and he/she woulnd not be prompted by a login dialog, and could simply view
> the report.
> I tried all sorts of different things (stored credentials in the datasource,
> impersonating a user, etc.) from both BIDS and Report Manager, but I can't
> seem to make it work. BTW, I can read the report just fine if I supply a
> user name and password.
> Thank you,
> --
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
The best option would be to use a report viewer control as part of a
custom ASP.NET application. A less desirable option would be to use
the Reporting Services Web Service to export the report and then allow
the user to view/download the report in that format (i.e., PDF, etc).
This link would help with this option.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsexecutionservice2005.reportexecutionservice.render.aspx
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||If you are not doing as Enrique is suggesting (i.e. you have your own app
that is being interfaced to) then you have one very poor possibility.
If you make the web sites (via IIS) anonymous this will work. However, you
will then have NO admin capability because everyone is anonymous. You would
need to switch off anonymous access everytime you want to perform any
administrative work.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:ehPSPdGNIHA.4480@.TK2MSFTNGP06.phx.gbl...
> Is it possible to access a report from the Internet (in a non Windows
> Domain context) without supplying any credentials. For instance, a user
> types in this URL:
> http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
> and he/she woulnd not be prompted by a login dialog, and could simply view
> the report.
> I tried all sorts of different things (stored credentials in the
> datasource, impersonating a user, etc.) from both BIDS and Report Manager,
> but I can't seem to make it work. BTW, I can read the report just fine if
> I supply a user name and password.
> Thank you,
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>|||Do you know if this would work with MSSQL 2005 Express running on XP Pro? I
tried setting anonymous access on IIS, and when I try to open a report from
the Internet, I'm prompted with a login that has a greyed-out user name
(MachineName\Guest) and an empty password. I'm trying to get rid of the
login altogether.
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:OsbHZzbNIHA.1212@.TK2MSFTNGP05.phx.gbl...
> If you are not doing as Enrique is suggesting (i.e. you have your own app
> that is being interfaced to) then you have one very poor possibility.
> If you make the web sites (via IIS) anonymous this will work. However, you
> will then have NO admin capability because everyone is anonymous. You
> would need to switch off anonymous access everytime you want to perform
> any administrative work.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
> news:ehPSPdGNIHA.4480@.TK2MSFTNGP06.phx.gbl...
>> Is it possible to access a report from the Internet (in a non Windows
>> Domain context) without supplying any credentials. For instance, a user
>> types in this URL:
>> http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
>> and he/she woulnd not be prompted by a login dialog, and could simply
>> view the report.
>> I tried all sorts of different things (stored credentials in the
>> datasource, impersonating a user, etc.) from both BIDS and Report
>> Manager, but I can't seem to make it work. BTW, I can read the report
>> just fine if I supply a user name and password.
>> Thank you,
>> --
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>|||Sorry, I don't know the answer to that.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
news:efA1J9bNIHA.3852@.TK2MSFTNGP06.phx.gbl...
> Do you know if this would work with MSSQL 2005 Express running on XP Pro?
> I tried setting anonymous access on IIS, and when I try to open a report
> from the Internet, I'm prompted with a login that has a greyed-out user
> name (MachineName\Guest) and an empty password. I'm trying to get rid of
> the login altogether.
> --
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:OsbHZzbNIHA.1212@.TK2MSFTNGP05.phx.gbl...
>> If you are not doing as Enrique is suggesting (i.e. you have your own app
>> that is being interfaced to) then you have one very poor possibility.
>> If you make the web sites (via IIS) anonymous this will work. However,
>> you will then have NO admin capability because everyone is anonymous. You
>> would need to switch off anonymous access everytime you want to perform
>> any administrative work.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Alain Quesnel" <alainsansspam@.logiquel.com> wrote in message
>> news:ehPSPdGNIHA.4480@.TK2MSFTNGP06.phx.gbl...
>> Is it possible to access a report from the Internet (in a non Windows
>> Domain context) without supplying any credentials. For instance, a user
>> types in this URL:
>> http://www.mydomain.com/ReportServer/Pages/ReportViewer.aspx?%2fMyFolder2%2fMyReport
>> and he/she woulnd not be prompted by a login dialog, and could simply
>> view the report.
>> I tried all sorts of different things (stored credentials in the
>> datasource, impersonating a user, etc.) from both BIDS and Report
>> Manager, but I can't seem to make it work. BTW, I can read the report
>> just fine if I supply a user name and password.
>> Thank you,
>> --
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>
>>
>

ABS () and dates

What would the Sql syntax look like if I wanted to select +/- 10 days of a d
elivery date.
For instance; Table has Actual Delivery Date & Expected Delivery date, and u
sing the ABS Sql function, I want to select only the rows from the table tha
t were delivered with +/- 10 days.
And even if it's not the best way to do it, I would really like the info on
ABS.
Any ideas?
Thanx!Use DATEADD function like:
BETWEEN DATEADD ( d, -10, dt ) AND DATEADD ( d, 10, dt )
Anith|||I don't know your table structure or sample data, but here's a guess:
WHERE ABS(DATEDIFF(DAY, ActualDate, ExpectedDate)) <= 10
"Jude" <judes@.email.uophx.edu> wrote in message
news:%23NQBlSwQGHA.1868@.TK2MSFTNGP09.phx.gbl...
What would the Sql syntax look like if I wanted to select +/- 10 days of a
delivery date.
For instance; Table has Actual Delivery Date & Expected Delivery date, and
using the ABS Sql function, I want to select only the rows from the table
that were delivered with +/- 10 days.
And even if it's not the best way to do it, I would really like the info on
ABS.
Any ideas?
Thanx!|||Trust me I would, but someone taking a class asked me this question & I said
I had never used this function, but knew where to go to ask the experts!
Thanx!
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:u1RNgfwQGHA.4960@.TK2MSFTNGP12.phx.gbl...
> Use DATEADD function like:
> BETWEEN DATEADD ( d, -10, dt ) AND DATEADD ( d, 10, dt )
> --
> Anith
>|||Fantastic, Thanx so much Aaron! This is a favor for a friend who is taking
a class, and since I haven't used this function & would just use DateDiff
functions, I didn't have an answer. I knew the experts in here would
though!
Thanx again!!!!!
"Aaron Bertrand [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:e%23zWkBxQGHA.1160@.TK2MSFTNGP09.phx.gbl...
>I don't know your table structure or sample data, but here's a guess:
> WHERE ABS(DATEDIFF(DAY, ActualDate, ExpectedDate)) <= 10
>
> "Jude" <judes@.email.uophx.edu> wrote in message
> news:%23NQBlSwQGHA.1868@.TK2MSFTNGP09.phx.gbl...
> What would the Sql syntax look like if I wanted to select +/- 10 days of a
> delivery date.
> For instance; Table has Actual Delivery Date & Expected Delivery date, and
> using the ABS Sql function, I want to select only the rows from the table
> that were delivered with +/- 10 days.
> And even if it's not the best way to do it, I would really like the info
> on ABS.
> Any ideas?
> Thanx!
>
>

about another instance of virtual server on sql2000 cluster

Hi,
i have a cluster a/p windows 2000 & SQL2000 , now i would like install
another virtual sever SQL on passive node for make this cluster
active/active.
The question is :
When i start a SQL wizard for add a new virtual server when installation
wizard aask me a path for sql binary i must use the same exist path use for
the virtual sql server installed or i must choice another path for ex.
c:\....\SQL\Virtual2 ?!?!?
Thanks.
--
No matter whether it's clustered or not, each SQL2000 instance has its own
location for its binaries (well some binaries for the tools are shared). You
can specify the same path, and the install will create a different folder
under that path for each instance. For instance, if you specify D:\MyDir for
the binaries (program files), the install will place the binaries under
D:\MyDir\MSSQL for the default instance, and under
D:\MyDir\MSSQL$<InstanceName> for a named instance.
Check out the section titled "File Paths for SQL Server 2000" in BOL.
Also, technically you don't really install another virtual server on the
passive node. Rather, you install another virtual server in the cluster, and
when you install it, the binaries are placed on all the nodes. You can
configure the virtual server to run on a particular node in its normal
operating mode.
Linchi
<io.com> wrote in message news:%23c$txrdzFHA.460@.TK2MSFTNGP15.phx.gbl...
> Hi,
> i have a cluster a/p windows 2000 & SQL2000 , now i would like install
> another virtual sever SQL on passive node for make this cluster
> active/active.
> The question is :
> When i start a SQL wizard for add a new virtual server when installation
> wizard aask me a path for sql binary i must use the same exist path use
> for the virtual sql server installed or i must choice another path for ex.
> c:\....\SQL\Virtual2 ?!?!?
> Thanks.
>
> --
> --
>
|||Thanks you!
"Linchi Shea" <linchi_shea@.NOSPAM.ml.om> wrote in message
news:ex9%23QsezFHA.3924@.TK2MSFTNGP14.phx.gbl...
> No matter whether it's clustered or not, each SQL2000 instance has its own
> location for its binaries (well some binaries for the tools are shared).
> You can specify the same path, and the install will create a different
> folder under that path for each instance. For instance, if you specify
> D:\MyDir for the binaries (program files), the install will place the
> binaries under D:\MyDir\MSSQL for the default instance, and under
> D:\MyDir\MSSQL$<InstanceName> for a named instance.
> Check out the section titled "File Paths for SQL Server 2000" in BOL.
> Also, technically you don't really install another virtual server on the
> passive node. Rather, you install another virtual server in the cluster,
> and when you install it, the binaries are placed on all the nodes. You can
> configure the virtual server to run on a particular node in its normal
> operating mode.
> Linchi
> <io.com> wrote in message news:%23c$txrdzFHA.460@.TK2MSFTNGP15.phx.gbl...
>
|||Sorry , a lat question :
i have isntalled the new virtual server and it work fine but i see that the
new instance of sql virtual server is myclustersql02\myclustersql02
Why ?
The first instance was call only "mycluster01" ...
Perhaps because all new instance of virtual server that i install are a "sql
named instance" ?
Thanks.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.om> wrote in message
news:ex9%23QsezFHA.3924@.TK2MSFTNGP14.phx.gbl...
> No matter whether it's clustered or not, each SQL2000 instance has its own
> location for its binaries (well some binaries for the tools are shared).
> You can specify the same path, and the install will create a different
> folder under that path for each instance. For instance, if you specify
> D:\MyDir for the binaries (program files), the install will place the
> binaries under D:\MyDir\MSSQL for the default instance, and under
> D:\MyDir\MSSQL$<InstanceName> for a named instance.
> Check out the section titled "File Paths for SQL Server 2000" in BOL.
> Also, technically you don't really install another virtual server on the
> passive node. Rather, you install another virtual server in the cluster,
> and when you install it, the binaries are placed on all the nodes. You can
> configure the virtual server to run on a particular node in its normal
> operating mode.
> Linchi
> <io.com> wrote in message news:%23c$txrdzFHA.460@.TK2MSFTNGP15.phx.gbl...
>
|||Precisely. Multiple instances on a cluster look and act just like multiple
instances on a stand-alone box. I typically use only named instances on a
cluster just to avoid naming confusion.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
<io.com> wrote in message news:%233DO2ipzFHA.268@.TK2MSFTNGP09.phx.gbl...
> Sorry , a lat question :
> i have isntalled the new virtual server and it work fine but i see that
> the new instance of sql virtual server is myclustersql02\myclustersql02
> Why ?
> The first instance was call only "mycluster01" ...
> Perhaps because all new instance of virtual server that i install are a
> "sql named instance" ?
> Thanks.
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.om> wrote in message
> news:ex9%23QsezFHA.3924@.TK2MSFTNGP14.phx.gbl...
>
|||<io.com>@.nirgendwo wrote:

> Thanks you!
[vbcol=seagreen]
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.om> wrote in message
> news:ex9%23QsezFHA.3924@.TK2MSFTNGP14.phx.gbl...
You can review too this MS paper:
http://support.microsoft.com/default...b;en-us;243218
Congrats!
coke.cl [-en-] gmail.com
http://www.foto-digital.cl/
|||:-)
Thanks for you time.
"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:uwzLStpzFHA.2132@.TK2MSFTNGP15.phx.gbl...
> Precisely. Multiple instances on a cluster look and act just like
> multiple instances on a stand-alone box. I typically use only named
> instances on a cluster just to avoid naming confusion.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
> <io.com> wrote in message news:%233DO2ipzFHA.268@.TK2MSFTNGP09.phx.gbl...
>
|||The only difference between multiple instances on a Clustered installation
versus a standalone is the Virtual Server name.
On a stand-alone, you can have 1 default instance and multiple named
instances, supported up to 15 or 16 named instances, which is true for a
clustered installation too. The reason being that any one node would need
to distinguish between the different binary sets just like a stand-alone,
registry keys, etc.
However, each virtual instance would also need a dedicated cluster group,
which requires a disk resource, IP and NAME.
So, for a stand-alone, you have server (default instance),
server\instance01, server\instance02, . . ., server\instance15. For a
clustered installation, virtual01 (default instance), virtual02\instance01,
virtual03\instance02, . . ., virtual16\instance15.
Sincerely,
Anthony Thomas

<io.com> wrote in message news:e3QVcj2zFHA.464@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
> :-)
> Thanks for you time.
>
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:uwzLStpzFHA.2132@.TK2MSFTNGP15.phx.gbl...
you[vbcol=seagreen]
the[vbcol=seagreen]
cluster,[vbcol=seagreen]
news:%23c$txrdzFHA.460@.TK2MSFTNGP15.phx.gbl...[vbcol=seagreen]
install
>