I'm new, I'm lost, I think I've installed the wrong this!

Hi folks

I've got experience of developing applications using relational databases, but I've never installed a database on my PC.

I've just downloaded and installed .NET Framework 2.0 without issues. I also did Visual C# Express with no problems and I've made a couple of example projects successfully.

What I wanted to do next was install SQL Server Express so I can design a database and then use Visual C# to create a GUI to do a simple add/edit/delete type scenario.

So, I have installed something called SQL Server 2005. I tried to install SQL Server Express, but for some reason it isn't called that on my list of programs.

When I open that up I have a choice of SQL Server Configuration Manager or SQL Server 2005 Surface Area Configuration. None of these look like what I was expecting - a nice Studio where I can create tables much like MS Access.

Perhaps I need to do something with one of these tools to get to where I want to be, or perhaps I am barking up the wrong tree and I need to do some uninstalling.

I wondered if someone could guide me? I feel so lost that I don't even know the right questions to ask to get the answers.

Thanks

Richard

The 'standard' installation for SQL Express does not include any 'client tools', i.e., "where I can create tables".

However, you can download and install the SQL Server Management Studio Express from:

SQL Server 2005 Express Books Online Express Edition
http://msdn2.microsoft.com/en-us/library/ms165706.aspx

SQL Server 2005 Express Edition (Advanced/SSMS)
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
http://msdn2.microsoft.com/en-us/library/ms365247.aspx
http://tinyurl.com/yelwr9

I included the url for Books Online -the definitive help source for SQL Server.

|||

Thank you kind sir.

I guessed there was another step to do but I just couldn't figure it out.

I'm downloading now, so if I have any issues with the installation I'll pop back for help. Or, I'll try the online book which looks like it'll be a great help.

Have a nice day.

I'm gonna SHOOT the @#$% server!

Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual directory
using the SQLXML IIS utility and all is well. BUT... when I try connecting
to the web service via VS.NET, I keep getting this...
ERROR: 400.100 Bad Request
HResult: 0x80004005
Source: Microsoft SQL isapi extension
Description: The virtual name could not be recognized
I even get that if I try browsing the WSDL file directly from IE.
Now I've checked the security, I've checked the configuration, I've checked
it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
Now the odd thing is if I disable the application on that virtual directory
(thus stopping the maaping through the DLL, I can properly browse the WSDL
file. HUH?
So... anyone got any ideas and if not, any bullets or a large mallet?
Mark
Please don't shoot.
I forwarded your problem to one of the people of the SQLXML team and hope he
will reply to you.
Best regards
Michael
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark
|||Hi there,
Do you have the SOAP Toolkit 2.0 installed? SqlXml 3.0 SP2 requires it for
using web services. However, if you can wait a bit longer, we will be
releasing SP3 which removes that dependency so SOAP Toolkit is no longer
needed.
Thanks,
Irwin
Irwin Dolobowsky
Program Manager, SqlXml
http://blogs.msdn.com/irwando
This posting is provided "AS IS" with no warranties, and confers no rights.
"Mark A. Donohoe" <Mark (at) MarkDonohoe.com> wrote in message
news:D27F9BE8-F783-41E8-83B8-8A3393EDF2F4@.microsoft.com...
> Ok, I've had it with this thing!!! I'm running Windows Server 2003, SQL
> Server 2000 with SP2 and SQLXML 3.0 SP2. I've configured a virtual
> directory
> using the SQLXML IIS utility and all is well. BUT... when I try
> connecting
> to the web service via VS.NET, I keep getting this...
> ERROR: 400.100 Bad Request
> HResult: 0x80004005
> Source: Microsoft SQL isapi extension
> Description: The virtual name could not be recognized
> I even get that if I try browsing the WSDL file directly from IE.
> Now I've checked the security, I've checked the configuration, I've
> checked
> it all but to no avail! I'm gonna take a #@.$% hammer to this box!!!
> Now the odd thing is if I disable the application on that virtual
> directory
> (thus stopping the maaping through the DLL, I can properly browse the WSDL
> file. HUH?
> So... anyone got any ideas and if not, any bullets or a large mallet?
> Mark

IIS and the web.config

Hi,

My application is acting weird and the research I've done leads me to an answer why it's breaking, but not how to fix it.

My web app is hosted by a remote company. I have the main website sitting in the root web directory and in a subfolder I have another application that will handle login and updating the content in the SQL 2K5 backend (not an Express DB).

The website itself is able to pull in informaiton from the DB without any trouble, so I know it's able to connect to the DB and everything is peachy. The login app though is acting as though it can't get to the DB. I've applied the ASPNET schema to the DB using the aspnet_regsql.exe from the framework and the login application is using the same connection string as the main website.

One thing to note here is that the website and the login app have seperate web.config files since they were developed as different projects.

With my customized provider defined in the web.config for the login app I get this error on page load:

"Parser Error Message:Itis an error to use a section registered asallowDefinition='MachineToApplication' beyond application level. Thiserror can be caused by a virtual directory not being configured as anapplication in IIS."

If I comment out the custom provider, the page loads but when I try to create a user it tells me that "...the SQL Server couldn't be contacted. This may be because it doesn't accept remote connections." Thing of it is that it's not a remote connection and it's the same connection string and db as the other site.

Now, the research I've done points at the two different web.config files, which makes sense. But how do I make the one web.config work for both the website and the subdirectory with the login app? Keep in mind that I can't create any new virtual directories or modify IIS since this is a remote hosting company.

Can someone help me understand the fix with a little more clarity?

Your admin application needs to be setup as a Virtual Directory. Your hosting company will have to do this for you. You know you can make it all one application and just control which Roles/Users have access to the admin folder in the web.config? :>

IIS and SQL Server on separate machine

Hi,
Can anybody please help me how to set up a conncetion between IIS & SQL
Server on seperate machine.
1. Domain is same
2. I've tried as per the article 176380, but we are facing some problem on
IIS. So my Network manager said I need to try something else.
Please let me know the steps that I have to do.
Thanks in Advance.
Kavi
"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
news:B3583882-BE7C-4419-8269-F8F8CA1EF44C@.microsoft.com...
> Can anybody please help me how to set up a conncetion between IIS & SQL
> Server on seperate machine.
> 1. Domain is same
> 2. I've tried as per the article 176380, but we are facing some problem on
> IIS. So my Network manager said I need to try something else.
What's the problem? And, what have you tried so far? More detail helps!
Steve
|||Hi Steve,
OK the following steps I've done.
1. Created a user account on the Domain Controller called
IUSR_MY_WEB.
2. Added this user account to the Guest Group of both SQL
Server & the IIS Machine.
3. On the computer where IIS is running the aninymous
login, the user name is set up as IUSR_MY_WEB
OK, the following step, I don't understand (What the
article 176380 says)
"On the computer that is hosting SQL Server, use the
Security manager to map the IUSR_MY_WEB account to an
existing user logon on SQL Server. For more Info on how
to do this, consult the SQL Server Documentation"
I tried to find more info from the Documentation & I'm
not successful.
What I did was I created a USER LOGIN in SQL Server as
DOMAIN\IUSR_MY_WEB.
In the ASP Program, I've used the OLE-DB Provider as
follows:
Dim oConn: Set oConn=Server.CreateObject
("ADODB.Connection")
'oConn.Open "Driver={SQL
Server};Server=SQLSERVERMACHINENAME;Network=DBMSSO CN;Datab
ase=MYDBASE;Uid=DOMAIN\IUSR_MY_WEB;Pwd="
Even I tried with IP address also.
Hope this info will gives you a clear picture, what am I
doing wrong?
Thanks.
>--Original Message--
>"Kavi" <Kavi@.discussions.microsoft.com> wrote in message
>news:B3583882-BE7C-4419-8269-
F8F8CA1EF44C@.microsoft.com...[vbcol=seagreen]
between IIS & SQL[vbcol=seagreen]
facing some problem on[vbcol=seagreen]
something else.
>What's the problem? And, what have you tried so far?
More detail helps!
>Steve
>
>.
>

IIF Function

I've been looking at the online help and it appears that
this statement should function as follows:
Select IIf(1 > 0 , 'Yes', 'No')
If 1 is greater than 0, Yes should be returned, if not
then No
Sql returns an error message: Incorrect syntax near '>'
Any Ideas?
Thanks
You must be looking at help for MS Access or Excel or something. There is
no such thing as IIF in SQL Server. Maybe try CASE:
SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
"Raghib" <anonymous@.discussions.microsoft.com> wrote in message
news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
> I've been looking at the online help and it appears that
> this statement should function as follows:
> Select IIf(1 > 0 , 'Yes', 'No')
>
> If 1 is greater than 0, Yes should be returned, if not
> then No
> Sql returns an error message: Incorrect syntax near '>'
> Any Ideas?
> Thanks
>
|||If you search for IIF in SQL Server Books Online, you will indeed find it.
However, you have to look at the title (or location) and realize it is for
Analysis Services only.
This is not a TSQL function, but rather an MDX function.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23GAGeFg8EHA.2600@.TK2MSFTNGP09.phx.gbl...
> You must be looking at help for MS Access or Excel or something. There is
> no such thing as IIF in SQL Server. Maybe try CASE:
> SELECT CASE WHEN 1 > 0 THEN 'Yes' ELSE 'No' END
>
>
> "Raghib" <anonymous@.discussions.microsoft.com> wrote in message
> news:100801c4f1fe$f73d1860$a301280a@.phx.gbl...
>