No login windows for DB

Greetings,
One of the DBs on my mssql server should ask for a login and password to change content. The content/DB is access via web page. Any suggestions as to why it has suddenly stopped challenging the user for login? I checked the services and all the necessary ones seems to be running.:confused:

Thanks in advance.
spdunneCheck your web browser settings. It is probably cached some how. Make sure you delete all cookies, history, etc. and try again.

Also make sure that the website is not using windows authentication; this will automatically log you into the db.

I suspect that this issue is either with the browser or web page, not the DB.

Good luck,
Hope this helped

No connection

Hello,

New development machine with Sql Server Express and Visual Web Developer.

I created a database then tried to connect from a test page on localhost and it worked. Then I tried from the internet domain and could not. So under the

Surface Area Configuration, I change the Remote Connections to Using both TCP/IP and named pipes and restarted the Database Engine. But

I still could not connect. So I restarted the machine. Now I can't view the page on localhost either. I can view a different web page so the Web server is

working.

I get the following as the exception:Error reading the database: Cannot open user default database. Login failed.Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.

My connection string is: "Data Source=.\SQLEXPRESS;Integrated Security=True;AttachDBFilename=|DataDirectory|Externalresearch.mdf;User Instance=True"

Any suggestions?

Okay I found out why. If I have Web Developer open (with the database connection open) I cannot connect from the browser. But

if I close Web Developer then I can connect from the browser (ie, view my test page).

Is this because it's the same machine that I am both viewing the web page and hosting Sql server (ie, the user can only be used once)?

|||

Hi,

It's a little strange that it says you're using the Network Service to connect to SQL Server.

Are you connecting to the SQL Server through Internet with the windows authentication? If so, that's not supported, since the windows identity cannot be passed through internet.

|||

Kevin,

Everything including the database is on one machine. I'm using Windows authentication. So when I'm in Visual developer and connect

to the database, my web page (again hosted on the same machine) cannot connect to the database. It's a new installation of everything

with defaults setup. How can I work on the database while my web pages can still access the database? I just downloaded Managament

Studio Express, will this do?

Thanks for any help

|||

Hi,

Yes, you can use Management Studio to grant database access permission to the Network Service account.

By default, it does not have permission to the SQL Server. After granting the access, it will be working fine, I think.

sql

NLB Web App accessing Cluster SQL 2005

Hello Friends
I have a project that will use Failover Cluster for SQL 2005 and NLB for the
web server front-end (using IIS).
That web application will be developed in-house. there are any special
programming considerations that the programmers must embed in the application
in order to support the special features of Failover and NLB clusters?
Does the web App Server must be Cluster-Aware to interact to SQL 2005
Failover Cluster?
Can you please give me any links to some documents that reflect these
situations?
Thanks for Help
Bruno
No. If it can connect to the SQL Server, you are set for the application.
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"Bruno" <Bruno@.discussions.microsoft.com> wrote in message
news:D6B04BF1-9730-46AA-A6E9-EBFC5C6B4C2D@.microsoft.com...
> Hello Friends
> I have a project that will use Failover Cluster for SQL 2005 and NLB for
> the
> web server front-end (using IIS).
> That web application will be developed in-house. there are any special
> programming considerations that the programmers must embed in the
> application
> in order to support the special features of Failover and NLB clusters?
> Does the web App Server must be Cluster-Aware to interact to SQL 2005
> Failover Cluster?
> Can you please give me any links to some documents that reflect these
> situations?
> Thanks for Help
> Bruno
|||Any SQL client application can connect to a SQL Cluster with no changes. I
recommend using non-persistent connections so the web app can recover in
case of a cluster failover, but that has been general programming practice
for a while now. Your NLB session model and the application session model
will need to work together. I.E. if you only support local sessions in IIS,
you will need to make sure your NLB sessions are "sticky". Your Network
Engineer can help with this.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Bruno" <Bruno@.discussions.microsoft.com> wrote in message
news:D6B04BF1-9730-46AA-A6E9-EBFC5C6B4C2D@.microsoft.com...
> Hello Friends
> I have a project that will use Failover Cluster for SQL 2005 and NLB for
> the
> web server front-end (using IIS).
> That web application will be developed in-house. there are any special
> programming considerations that the programmers must embed in the
> application
> in order to support the special features of Failover and NLB clusters?
> Does the web App Server must be Cluster-Aware to interact to SQL 2005
> Failover Cluster?
> Can you please give me any links to some documents that reflect these
> situations?
> Thanks for Help
> Bruno
|||You need to have reconnect logic built into the application. Whenever a
failover occurs, you will loose connectivity. The advantage of this
solution, however, is that the failover happens automatically, and is
relatively brief.
On the NLB, you need to program "stateless" apps. That is, you can not
guarantee that recovered session are redirect to the same web server during
each pass. If only one server is aware of the state, you find the user
orphaned if redirected to one of the other servers.
Also, to keep your solution clean and to harden security, consider using
some sort of middleware, either through dedicated application hosts, or some
sort of messaging platform.
Sincerely,
Anthony Thomas

"Bruno" <Bruno@.discussions.microsoft.com> wrote in message
news:D6B04BF1-9730-46AA-A6E9-EBFC5C6B4C2D@.microsoft.com...
> Hello Friends
> I have a project that will use Failover Cluster for SQL 2005 and NLB for
the
> web server front-end (using IIS).
> That web application will be developed in-house. there are any special
> programming considerations that the programmers must embed in the
application
> in order to support the special features of Failover and NLB clusters?
> Does the web App Server must be Cluster-Aware to interact to SQL 2005
> Failover Cluster?
> Can you please give me any links to some documents that reflect these
> situations?
> Thanks for Help
> Bruno

Newcomer needs help with a SQL Query

Hi, I’m new to this list and looking for some help (my SQL is not brillian
t
to say the least) and information I’ve found on the web is confusing me
further.
It’s related to an SMS Web report, but I think it’s more of a SQL relate
d
question.
I am trying to pull a count of all specified programs in use in a collection
with a count of which machines they are installed on. I’ve had no problem
doing this. Query is as follows …
Select DISTINCT arp.DisplayName0, count(*) as 'Count', @.CollID as Collection
ID
FROM v_R_System sys
JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE (arp.DisplayName0 in ('3D+ 4.1 OEM Ed.')
or arp.DisplayName0 in ('3D+ 5.0 (AutoCAD)')
or arp.DisplayName0 in ('3D+ 5.2 (AutoCAD 2004)')
or arp.DisplayName0 in ('3D+ 5.2 (AutoCAD)')
or arp.DisplayName0 in ('3D+ 5.2 OEM Ed.')
or arp.DisplayName0 in ('3D+ ADT 2004')
or arp.DisplayName0 in ('3D+ ADT 2005')
or arp.DisplayName0 in ('3D+ V6.00 (AutoCAD 2004)')
or arp.DisplayName0 in ('Ward Toolkit')
or arp.DisplayName0 in ('West Point Bridge Designer 2005')
or arp.DisplayName0 in ('Xsteel 7.0','Xsteel 7.1','Xsteel 8.0')
or arp.DisplayName0 in ('XTRACT'))
and fcm.CollectionID=@.CollID
GROUP BY DisplayName0
ORDER BY Displayname0
Problem is that arp.DisplayName0 contains some duplicate entries (they are
not actually duplicates, there is a further column in the view called ProdID
0
and this is where the duplicate entries occur).
What I need to do is count only the first occurrence of each item in
arp.DisplayName0 for each computer and ignore the rest. I thought that SELEC
T
DISTINCT would do this, but it has no effect.
Can anyone help?
Thanks in advance …
________________________________________
________
Rob Stack MBCS CITP IEngPlease post DDL, sample data and expected results. Without that any attempt
at helping you is a guessing game.
Se this:
http://www.aspfaq.com/etiquette.asp?id=5006
ML
http://milambda.blogspot.com/|||>Select DISTINCT arp.DisplayName0, count(*) as 'Count', @.CollID as CollectionIDed">
>FROM v_R_System sys
>JOIN v_GS_ADD_REMOVE_PROGRAMS arp ON sys.ResourceID = arp.ResourceID
>JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
>WHERE (arp.DisplayName0 in ('3D+ 4.1 OEM Ed.')
>or arp.DisplayName0 in ('3D+ 5.0 (AutoCAD)')
>or arp.DisplayName0 in ('3D+ 5.2 (AutoCAD 2004)')
>or arp.DisplayName0 in ('3D+ 5.2 (AutoCAD)')
>or arp.DisplayName0 in ('3D+ 5.2 OEM Ed.')
>or arp.DisplayName0 in ('3D+ ADT 2004')
>or arp.DisplayName0 in ('3D+ ADT 2005')
>or arp.DisplayName0 in ('3D+ V6.00 (AutoCAD 2004)')
>or arp.DisplayName0 in ('Ward Toolkit')
>or arp.DisplayName0 in ('West Point Bridge Designer 2005')
>or arp.DisplayName0 in ('Xsteel 7.0','Xsteel 7.1','Xsteel 8.0')
>or arp.DisplayName0 in ('XTRACT'))
>and fcm.CollectionID=@.CollID
>GROUP BY DisplayName0
>ORDER BY Displayname0
Just a small aside, you can simplify that WHERE clause quite a bit by
actually using the IN test in a more conventional manner:
WHERE arp.DisplayName0
IN ('3D+ 4.1 OEM Ed.',
'3D+ 5.0 (AutoCAD)',
'3D+ 5.2 (AutoCAD 2004)',
'3D+ 5.2 (AutoCAD)',
'3D+ 5.2 OEM Ed.',
'3D+ ADT 2004',
'3D+ ADT 2005',,
'3D+ V6.00 (AutoCAD 2004)',
'Ward Toolkit',
'West Point Bridge Designer 2005',
'Xsteel 7.0','Xsteel 7.1','Xsteel 8.0',
'XTRACT')
Roy

newbies help 2 questions

There is 1 error when i tried to install msde into my window 2003 server web edition.
1. I use command prompt to enter c:\\sql2ksp3>setup SAPWD=aA1234567
the errors is "go to the control panel to install and configure system components"
How do i install ?

Sql client for 2003 server web edition
2. i tried to install sql client in window 2003 web edition but the msdn cd could not start after i double click on the setupsql.exe. I thought the sql client can be install but not the server on web edition ?I have solve Q1 above by using run the type in
Setup.exe /qb+ INSTANCENAME=NetSDK DISABLENETWORKPROTOCOLS=1 SAPWD=<YOUR SA PASSWORD
It seems you cannot double click on the setup.exe in the extracted folder and you cannot use the ms-dos command prompt becuase both return errors like,
"A strong SA password is required for security reason. Please us SAPWD switch to supplyt he same. Refer to readme for more details. Setup will now exits."
or
"Go to the control panel to install and configure system components"

Hope some one can help on Q2|||I think you can not install sql clinet tools on 2003 WE

Newbie: XML as datasource

Hi everyone,
I have a Web Form with data fields. What I want to do is to save these
fields into an XML file (dynamically), then hook this XML (as a data source)
to a SQL Report so that I don't have to save these data into a SQL Server
database. Is it possible? If it is then can someone show me how.
Any suggestion is greatly appreciated.
Many thanks in advance.There is currently no support for accessing an XML data source. You either
have to write your own custom XML data source extension or look on the market
for an XML OLEDB provider. Or search MSDN for sample code that implements an
XML data source extension. My current understanding is that it will be
included with the SQL Server 2005 release of Reporting Services.
HTH
Charles Kangai, MCT, MCDBA
"Calvin KD" wrote:
> Hi everyone,
> I have a Web Form with data fields. What I want to do is to save these
> fields into an XML file (dynamically), then hook this XML (as a data source)
> to a SQL Report so that I don't have to save these data into a SQL Server
> database. Is it possible? If it is then can someone show me how.
> Any suggestion is greatly appreciated.
> Many thanks in advance.|||Hi
I used the "Microsoft OLE DB Simple Provider"
1.) Create new Shared Data Source
General: "Provider=MSDAOSP.1;Data Source=MSXML2.DSOControl.2.6"
Credentials: "Use Windows Authentication (Integrated Security)"
2.) Create new Report using this Shared Data Source
Query: path to the xml-file "c:\temp\test.xml"
Kind Regards
Daniel
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:4A0288C1-9C16-4CDF-981A-88B89475616C@.microsoft.com...
> There is currently no support for accessing an XML data source. You either
> have to write your own custom XML data source extension or look on the
> market
> for an XML OLEDB provider. Or search MSDN for sample code that implements
> an
> XML data source extension. My current understanding is that it will be
> included with the SQL Server 2005 release of Reporting Services.
> HTH
> Charles Kangai, MCT, MCDBA
> "Calvin KD" wrote:
>> Hi everyone,
>> I have a Web Form with data fields. What I want to do is to save these
>> fields into an XML file (dynamically), then hook this XML (as a data
>> source)
>> to a SQL Report so that I don't have to save these data into a SQL Server
>> database. Is it possible? If it is then can someone show me how.
>> Any suggestion is greatly appreciated.
>> Many thanks in advance.

newbie: True and False 0 and 1?

Hi,
I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
writing a little basic web app. One of the fields I have set to bit
which I assumed I would use for True or False (1 or 0) - Using
Dreamweaver it seems that when I check a field in order to set it to
"true" it seems to have a value of -1 in the table? Why is this? Can
anyone shed some light for me
cheers
Baronne
On 11 Mar 2005 07:56:29 -0800, Baronne wrote:

>I have an MSDE 2000 SP3a running on Win2k3, problem I have is that I am
>writing a little basic web app. One of the fields I have set to bit
>which I assumed I would use for True or False (1 or 0) - Using
>Dreamweaver it seems that when I check a field in order to set it to
>"true" it seems to have a value of -1 in the table? Why is this? Can
>anyone shed some light for me
Hi Baronne,
The BIT datatype is not boolean. It is numeric, with only the values 0
and 1 allowed. Some people use BIT to represent booleans, but you'll
have to convert true to 1 (or 0) and false to 0 (or 1), and back again,
when going to and from the database.
Since SQL Server has no boolean datatype, you can pick wahtever you
want. I usually use a CHAR(1) datatype, with a CHECK constraint to make
sure that only 'T' or 'F' are allowd (or 'Y' / 'N' - depending on the
specific case).
Best, Hugo
(Remove _NO_ and _SPAM_ to get my e-mail address)

newbie: Preview in VS.NET looks great, RS has poor alignment

hi folks
(newbie question) why in VS.NET, my preview'd reports look wonderful (from
imported MS Access report definitions), BUT from the web they look awful...
Am I possibility (most likely) missing something? One would believe that the
preview in VS.NET would be the same rendering mechanism from RS?
column heading misalignment, field misalignment, etc.
Respectfully
Robthat's normal, by grouping elements (that should stay together) in a
rectangle you can greatly improve your control of the web-layout
"RobKaratzas" wrote:
> hi folks
> (newbie question) why in VS.NET, my preview'd reports look wonderful (from
> imported MS Access report definitions), BUT from the web they look awful...
> Am I possibility (most likely) missing something? One would believe that the
> preview in VS.NET would be the same rendering mechanism from RS?
> column heading misalignment, field misalignment, etc.
> Respectfully
> Rob|||Hi Antoon,
I've had this problem as well...what do you mean by 'grouping in a
rectangle'?
My way of solving this problem was to create a table that called a SP
that returned exactly one row and then put what I wanted into the
table. It worked, but I figured there must be a better way...
Peter|||If you want to keep report-elements together (textboxes, rectangles, lines,
immages,...). You draw a (transparent) rectangle first and then draw (ore
move) alle your elements in this rectangle.
The rectangle functions as a container (you move alle the elements by moving
the rectangle. And the elements will not "rearange themselfs" if they are
closly contained
"Peter Nolan" wrote:
> Hi Antoon,
> I've had this problem as well...what do you mean by 'grouping in a
> rectangle'?
> My way of solving this problem was to create a table that called a SP
> that returned exactly one row and then put what I wanted into the
> table. It worked, but I figured there must be a better way...
> Peter
>|||hi
I tried this with just the Page Header (by putting everything in a
rectangle). Can tell I did it right since moving the rectangle moves all of
the texboxes, but this had no effect whatsoever. (Again, the preview in
VS.NET looks wonderful, but the browser 'View Report' is very mangled (with
items getting cut-off, being moved to a new line vs. sized correctly.)
Am I missing something here?
Rob
(I am a newbie, but I use to teach MS Access classes back in 95-97 and was a
cert'd access and developer, so I wouldn't consider myself untrainable.)
"Antoon" wrote:
> If you want to keep report-elements together (textboxes, rectangles, lines,
> immages,...). You draw a (transparent) rectangle first and then draw (ore
> move) alle your elements in this rectangle.
> The rectangle functions as a container (you move alle the elements by moving
> the rectangle. And the elements will not "rearange themselfs" if they are
> closly contained
> "Peter Nolan" wrote:
> > Hi Antoon,
> > I've had this problem as well...what do you mean by 'grouping in a
> > rectangle'?
> >
> > My way of solving this problem was to create a table that called a SP
> > that returned exactly one row and then put what I wanted into the
> > table. It worked, but I figured there must be a better way...
> >
> > Peter
> >
> >|||You might be missing something.
On the menu go to Report > Report Properties and under layout ensure that
the Page width minus left and right margins is >= your report body width.
e.g. Most of my reports are landscape 11" with .5" margins. So when I create
reports I can only stretch the body to 10" or it will give me unexpected
results in the browser or when printed.
HTH.
Cheerios.
"Rob" <Rob@.discussions.microsoft.com> wrote in message
news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> hi
> I tried this with just the Page Header (by putting everything in a
> rectangle). Can tell I did it right since moving the rectangle moves all
of
> the texboxes, but this had no effect whatsoever. (Again, the preview in
> VS.NET looks wonderful, but the browser 'View Report' is very mangled
(with
> items getting cut-off, being moved to a new line vs. sized correctly.)
> Am I missing something here?
> Rob
> (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
a
> cert'd access and developer, so I wouldn't consider myself untrainable.)
> "Antoon" wrote:
> > If you want to keep report-elements together (textboxes, rectangles,
lines,
> > immages,...). You draw a (transparent) rectangle first and then draw
(ore
> > move) alle your elements in this rectangle.
> > The rectangle functions as a container (you move alle the elements by
moving
> > the rectangle. And the elements will not "rearange themselfs" if they
are
> > closly contained
> >
> > "Peter Nolan" wrote:
> >
> > > Hi Antoon,
> > > I've had this problem as well...what do you mean by 'grouping in a
> > > rectangle'?
> > >
> > > My way of solving this problem was to create a table that called a SP
> > > that returned exactly one row and then put what I wanted into the
> > > table. It worked, but I figured there must be a better way...
> > >
> > > Peter
> > >
> > >|||hi
double-checked what you said and all of my margins as well as width are fine.
(and would be glad to send you screenshots, just to clariy what I'm seeing.
thing that puzzles me is that these are reports that the import has
determined how to best interpret the layout. I'm in the process of migrating
60 of them and will let everyone know if I have any 'breakthroughs')
made no difference (width 10.5, margins 0.0)
but thanks, rob
"Nice_Out" wrote:
> You might be missing something.
> On the menu go to Report > Report Properties and under layout ensure that
> the Page width minus left and right margins is >= your report body width.
> e.g. Most of my reports are landscape 11" with .5" margins. So when I create
> reports I can only stretch the body to 10" or it will give me unexpected
> results in the browser or when printed.
> HTH.
> Cheerios.
> "Rob" <Rob@.discussions.microsoft.com> wrote in message
> news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> > hi
> >
> > I tried this with just the Page Header (by putting everything in a
> > rectangle). Can tell I did it right since moving the rectangle moves all
> of
> > the texboxes, but this had no effect whatsoever. (Again, the preview in
> > VS.NET looks wonderful, but the browser 'View Report' is very mangled
> (with
> > items getting cut-off, being moved to a new line vs. sized correctly.)
> >
> > Am I missing something here?
> >
> > Rob
> > (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
> a
> > cert'd access and developer, so I wouldn't consider myself untrainable.)
> >
> > "Antoon" wrote:
> >
> > > If you want to keep report-elements together (textboxes, rectangles,
> lines,
> > > immages,...). You draw a (transparent) rectangle first and then draw
> (ore
> > > move) alle your elements in this rectangle.
> > > The rectangle functions as a container (you move alle the elements by
> moving
> > > the rectangle. And the elements will not "rearange themselfs" if they
> are
> > > closly contained
> > >
> > > "Peter Nolan" wrote:
> > >
> > > > Hi Antoon,
> > > > I've had this problem as well...what do you mean by 'grouping in a
> > > > rectangle'?
> > > >
> > > > My way of solving this problem was to create a table that called a SP
> > > > that returned exactly one row and then put what I wanted into the
> > > > table. It worked, but I figured there must be a better way...
> > > >
> > > > Peter
> > > >
> > > >
>
>|||it actually prints real nice, in terms of layout... (close to how the VS.NET
preview looks).
rob
"RobKaratzas" wrote:
> hi
> double-checked what you said and all of my margins as well as width are fine.
> (and would be glad to send you screenshots, just to clariy what I'm seeing.
> thing that puzzles me is that these are reports that the import has
> determined how to best interpret the layout. I'm in the process of migrating
> 60 of them and will let everyone know if I have any 'breakthroughs')
> made no difference (width 10.5, margins 0.0)
> but thanks, rob
> "Nice_Out" wrote:
> > You might be missing something.
> > On the menu go to Report > Report Properties and under layout ensure that
> > the Page width minus left and right margins is >= your report body width.
> > e.g. Most of my reports are landscape 11" with .5" margins. So when I create
> > reports I can only stretch the body to 10" or it will give me unexpected
> > results in the browser or when printed.
> >
> > HTH.
> > Cheerios.
> >
> > "Rob" <Rob@.discussions.microsoft.com> wrote in message
> > news:037C6FCF-0078-4AA2-8C37-AFD0173FCC04@.microsoft.com...
> > > hi
> > >
> > > I tried this with just the Page Header (by putting everything in a
> > > rectangle). Can tell I did it right since moving the rectangle moves all
> > of
> > > the texboxes, but this had no effect whatsoever. (Again, the preview in
> > > VS.NET looks wonderful, but the browser 'View Report' is very mangled
> > (with
> > > items getting cut-off, being moved to a new line vs. sized correctly.)
> > >
> > > Am I missing something here?
> > >
> > > Rob
> > > (I am a newbie, but I use to teach MS Access classes back in 95-97 and was
> > a
> > > cert'd access and developer, so I wouldn't consider myself untrainable.)
> > >
> > > "Antoon" wrote:
> > >
> > > > If you want to keep report-elements together (textboxes, rectangles,
> > lines,
> > > > immages,...). You draw a (transparent) rectangle first and then draw
> > (ore
> > > > move) alle your elements in this rectangle.
> > > > The rectangle functions as a container (you move alle the elements by
> > moving
> > > > the rectangle. And the elements will not "rearange themselfs" if they
> > are
> > > > closly contained
> > > >
> > > > "Peter Nolan" wrote:
> > > >
> > > > > Hi Antoon,
> > > > > I've had this problem as well...what do you mean by 'grouping in a
> > > > > rectangle'?
> > > > >
> > > > > My way of solving this problem was to create a table that called a SP
> > > > > that returned exactly one row and then put what I wanted into the
> > > > > table. It worked, but I figured there must be a better way...
> > > > >
> > > > > Peter
> > > > >
> > > > >
> >
> >
> >