Database

20-Oct-09 20:15

But one that has me baffled. Yes, I've Googled, I've checked the online help, but I can't find an answer to this stupid question. Be kind - I'm old...

I have SQL Server Express 2008 installed on my server and, for various reasons, I want to develop a db app on a WinXP client machine using the server instance. How do I connect to it? The local copy of the SQL Server Management tool only "sees" the local instance of SQL Server Ex 2005 on the XP client. I know a better solution would be to install the more recent version on the client, but it's a problem to do so. The client has a ton of RAM, but almost no drive space and no way to add more, while the server has little RAM and over a TB of drive space available. I really want to work from the client, but host everything on the server.

Any tips? Confused | :confused:

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

SeMartens20-Oct-09 20:41

SeMartens

20-Oct-09 20:41

Hi,

I guess the problem is not that you are using an SQL Server 2005 Management Studio. To "see" the server on your client machine you need to start the SQL Server-Browser service on your server machine. This service propagates the name of the local sql server to remote machines.

Let me know if this helps you.

Regards
Sebastian

It's not a bug, it's a feature!

Check out my CodeProject article Permission-by-aspect.

Me in Softwareland.

Roger Wright21-Oct-09 3:12

21-Oct-09 3:12

Thanks, Sebastion - it worked, at least partially. I can "see" the database engine on the server, but I can't connect. I'll need to configure it to accept remote connections first. Back to the books to find out how...

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

i.j.russell21-Oct-09 3:09

i.j.russell

21-Oct-09 3:09

By default, Sql Server Express is local only. You need to allow remote connections through the Surface Area Configuration tool accessed via your Start menu. I can't remeber if it is installed by default or if you need to install Management Studio Express to get access to it.

Roger Wright25-Oct-09 21:40

25-Oct-09 21:40

Thanks!

The 2008 version doesn't have a Surface Area Configuration tool; it's built in to the Management Studio. All protocols are enabled ( my doing, not the default ), but when I try to connect from the client I receive error 10061 - the target server actively refused the connection. I'm logged in as an Admin on both machines, and the SQL Server Browser service is running on the server. Perhaps I have to install the 2008 version of the management studio on the client... Any thoughts on that?

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Gary R. Wheeler29-Oct-09 13:04

Gary R. Wheeler

29-Oct-09 13:04

With SQL Server 2005 Express, it seems I had to modify security settings to make it accept remote connections. I'm afraid I'm not very good at this sort of thing; my approach was to mash on the keys until it gave up in disgust and did what I wanted.

Software Zen: delete this;
Fold With Us![^]

Roger Wright29-Oct-09 18:04

Primary key on Bit Datatype in sql server 2000

29-Oct-09 18:04

I may try your approach; nothing Microsoft has to suggest works.

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

Tufail Ahmad20-Oct-09 19:30

Tufail Ahmad

20-Oct-09 19:30

How can i assign primary key to a field having BIT datatype in sql server 2000.

Thanks
Tufail

Mycroft Holmes20-Oct-09 19:53

Mycroft Holmes

20-Oct-09 19:53

A bit data type stores ones or zeros, you intend to have only 2 records in your table? I generally use int but even there I have run into the 32k limit.

Eddy Vluggen20-Oct-09 23:32

Eddy Vluggen

20-Oct-09 23:32

To an existing table, or a new table?

DECLARE @TestTable TABLE(
	[col1] bit NOT NULL PRIMARY KEY,
	[col2] varchar(10) NULL
) 

INSERT @TestTable
  SELECT 0, 'item 1'
  UNION ALL
  SELECT 1, 'item 2'

SELECT *
  FROM @TestTable;

Results in;

col1 col2
----- ----------
0 item 1
1 item 2

INSERT @TestTable (col1, col2) VALUES (9, 'item 3')

Will fail, since "9" is too large a value for type 'BIT'. The error will say that it's duplicate, since it tries to convert the "9" to a BIT, resulting in the value "1":

PRINT CAST(9 AS BIT)

Results in "1"

INSERT @TestTable (col1, col2) VALUES (1, 'item 42')

Will fail due to the primary key, since there's already an item with a value "1" for col1.

I are Troll Suspicious | :suss:

Mycroft Holmes21-Oct-09 0:44

Mycroft Holmes

21-Oct-09 0:44

Slow day up North is it, besides 42 ALWAYS works, your definition of BIT must be wrong.

Never underestimate the power of human stupidity
RAH

Eddy Vluggen21-Oct-09 0:57

Eddy Vluggen

21-Oct-09 0:57

Mycroft Holmes wrote:
Slow day up North is it, besides 42 ALWAYS works, your definition of BIT must be wrong.

I'm slow in thinking today. Item 42 shouldn't work, since there already is an item with the pk-value of "1" inserted into the table.

BIT = { 0 | 1 }, and the first INSERT statement should fill the table to it's maximum capacity.

I are Troll Suspicious | :suss:

Mycroft Holmes21-Oct-09 1:01

Mycroft Holmes

21-Oct-09 1:01

Eddy Vluggen wrote:
I'm slow in thinking today

Sure are, 42 is tha answer to EVERYTHING, reference Hitchhikers Guide to the Galaxy. Oops missed the joke icon....

Never underestimate the power of human stupidity
RAH

Avoid login for BUILTIN\Administrator

Eddy Vluggen21-Oct-09 1:29

Eddy Vluggen

21-Oct-09 1:29

That's one magic number that I shouldn't have missed WTF | :WTF:

I are Troll Smile | :)

ArielR20-Oct-09 11:54

ArielR

20-Oct-09 11:54

I have a Sql Express instaled at XP Prof. I need to avoid to the BUILTIN\Administrator to init session.
Thanks

Re: Avoid login for BUILTIN\Administrator

Roger Wright20-Oct-09 20:02

Re: Avoid login for BUILTIN\Administrator

20-Oct-09 20:02

This is a statement, not a question. But I'll take a whack at it anyway, and try to guess what you're trying to ask.

I'm guessing that you're looking for a way to avoid using the built-in Administrator account for your application. You can use Windows Authentication and assign access rights to users there, or you can create a new user in SQL Server Express and use that account for access. I believe you can assign Roles to users in SQL Server; Administrator would not be my first choice, unless you need this account to have full control over everything in the server. You might want to spend a few nights reading up about users and roles in the online help system before you jump into anything.

And no, I'm not an expert, but a newbie like you, as you can tell from the dumb question I'll be posting as soon as I submit this. But I have spent some time studying, and it's definitely worthwhile. Big Grin | :-D

"A Journey of a Thousand Rest Stops Begins with a Single Movement"

ArielR21-Oct-09 1:53

ArielR

21-Oct-09 1:53

The problem ( or my be not ) is that you need administrator right to perform hard or soft maintenance in XP SO. and I want avoid that maintenance team have access to the databases. As we know BUILTIN\Administrator is derived from windows access rights. I've created a Sql login account with sysadmin rights but i can't to change permissions of BUILTIN\Administrator( for ex. avoid to init session). I don't know how do that..... thanks.

date issue

Tauseef A20-Oct-09 9:03

Tauseef A

20-Oct-09 9:03

hi guys
i want to get date values from my table in format like October-09
how can i do that ?
regards.

Tauseef A Khan
MCP Dotnet framework 2.0.

Richard MacCutchan20-Oct-09 9:16

Richard MacCutchan

20-Oct-09 9:16

Tauseef A wrote:
i want to get date values from my table in format like October-09

Date values have no format, they are just numbers. It is only when they are displayed that you apply whatever format you want.

Tauseef A wrote:
MCP Dotnet framework 2.0.

Aman Bhullar20-Oct-09 19:19

Aman Bhullar

20-Oct-09 19:19

Tauseef A wrote:
i want to get date values from my table in format like October-09

You can use the below queries

SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD]
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY]

For more information kindly refer to link
http://www.sql-server-helper.com/tips/date-formats.aspx[^]

Regards
Aman Bhullar
www.arlivesupport.com[^]

J4amieC20-Oct-09 22:37

J4amieC

20-Oct-09 22:37

Aman Bhullar wrote:
SELECT DATENAME(MM, GETDATE()) + ' ' + CAST(DAY(GETDATE()) AS VARCHAR(2)) AS [Month DD]
SELECT REPLACE(RIGHT(CONVERT(VARCHAR(11), GETDATE(), 106), 8), ' ', '-') AS [Mon-YYYY]

Neither of these give the OP what they asked for.

The first gives "October 21" the second "Oct-2009"

Aman Bhullar21-Oct-09 2:54

Aman Bhullar

21-Oct-09 2:54

Try using

SELECT DATENAME(MM, GETDATE()) + ' ' + RIGHT(CAST(YEAR(GETDATE()) AS VARCHAR(4)), 2) AS [Month YY]

This will give the result in the desired format

Regards
Aman Bhullar
www.arlivesupport.com[^]