[SQL 2005 Express] Question on Business Intelligence Development Studio (VS2005)

I am trying to create a report using BI Development Studio.

In Pivot Table, I can change the presentation of the data area to align with row or column, just like this:
http://img164.imageshack.us/img164/2055/untitledsi4.png

However, I can't seem to do that in BI Development Studio while designing the report. Does any of you know how to change the presentation of the data area of a report?

This is how it looks like now, the data area is sticking to the COLUMN, but I need them to stick with ROW so that I can handle more columns...
http://img103.imageshack.us/img103/4066/untitlednc8.pngmanage to resolve it by inserting just 1 details, then insert "Add ROW" at the details. This thing doesn't come with the Wizard. :D

[news] free copy of SQL Prompt

so last week i finally downloaded and installed SQL Server 2005, and along with that, i downloaded Studio Express (i had previoulsy been using MSDE with WinSQL by Synametrics)

anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate

i tried it, and i like it!!

see http://builder.com.com/5100-6388_14-6085249.html?part=rss&subj=bldrEDIT - Coo - my first post did stick|||anyhow, today i got an alert from google (you guys use those, right?) that there's a free copy of something called SQL Prompt available from Red Gate

i tried it, and i like it!!Harrumph. I paid $25 USD for my copy before Red Gate bought the product. So long as they keep developing it though (doesn't pick up functions, can't handle subqueries and derived tables etc yet) then I am happy :)

[MS Sql] Data type nvarchar

Hi everybody,

I'm using SQL Server Management Studio Express.
I'm trying to create a field which contains a text entered by the user. So, it should be able to contain at least 500 characters.

I used the type "nvarchar(MAX)". The problem is that the type contains about 50 characters max!!
I couldn't find out where and how to fix that.
If you have any idea :)

Thanks a lotType over the the MAX with the desired length of 500.|||Hi tmorton
Of course I tried nvarchar(500) (forgot to tell that). But it's not working either.
It sounds like nvarchar(MAX) is the max length type, and limited to about 50...
Thanks for your reply. And if someone has any idea :)|||That's all it takes from the SQL Server end. If you are only managing to store 50 characters in that column, then I would venture a guess that your data is being truncated before it hits the database. What does your code look like that is adding the data to your table?|||I believe that SQL Management Studio truncates text that it displays. Use something else to view/edit the column.|||Hi
It's weird, it's working now. And yet I didn't change anything particular. Maybe a "bug" on SQL Server... weird though. Thanks a lot to you guys :)

[DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied

ok im a CS student, installed visual studio .net, and im trying to connect to a ms sql database (Northwind), but I keep getting a error that "[DBNETLIB][ConnectionOpen(Connect()).] SQLServer does not exist or access denied" in visual studio whenever I try creating a new database connection. How do I know if SQL server is installed on my system? cuz in my systray I see SQL server service manager, is that the same thing as SQL server? or do I need to download the full version or something? also could it be that a certain port on my system is not open that SQL server requires to be open?

Thanks

Ron

The tray icon doesn't mean SQL is running, so use the tray icon to start SQL if it isn't. I do not know if SQL Express uses a tray icon, so i would assume you are using MSDE 2000. You might need to grant the user ASPNET access to the database.

SQL uses Port 1433. DTE services use ports 5000-5020, however I don't think you are using DTE.

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().]SSL Server error

For some reason, I'm no longer able to connect to any database on SQL Server.

If I click on the + sign before a Data Connection in Visual Studio Server Explorer, a Logon dialog opens. Whatever I enter in the dialog results in the following error message:

Connection failed.

Sql State: '0 80001'

Sql Server Error: 18

[DBNETLIB][ConnectionClient(SEDC.ClientHandshake().] SSL Server error

Help please.

What version of SQL Server are you using?

Have you tried connecting through some other method, such as using sqlcmd/osql or Management Studio/Query Analyzer?

What errors appear in the server errorlog?

Thanks
Laurentiu

|||

I'm using SQL Server 2000.

I've tried several ways to connect, all unsuccessful.

With Management Studio, I get the following error:

Cannot connect to COMPAC

Additional Information:

A connection was successfully established with the server, but then an error occurred during the pre-login handshake (provider: SSL Provider, error: 0- The token supplied to the function is invalid) (Microsoft SQL Server)

With Query Analyzer

Unable to connect to server COMPAC

Server: Msg 18, level 16, State 1

[Microsoft]]ODBE SQL Server Driver]

[Shared Memory] SSL Security Error

With Enterprise Manager

A connection could not be established to (local)

Reason: SSL Security error

Connection Open (SECDoClientHandshake())

Please verify SQL Server is running and check your SQL Server registration properties(by right-clicking on the (local) node and try again.

(The Server was running according to SQL Service Manager, and right-clicking said node/properties returned the same error)

Thanks for your consideration.

|||

Is there an error in the server errorlog? Look into MSSQL\Log directory for the latest ERRORLOG files. If there is an error there, please add it to this thread.

I'll move the thread to the data access forum, where someone might be able to help with this issue.

Thanks
Laurentiu

|||

I'm not up on reading the errorlog, so I've posted it at

http://www.e-windowsonline.com/errorlog.html

Thanks again

|||

The errorlogs don′t show anything in this case, the database is started up just fine. Have a look at the articles [1] and [2] at KB. Seems that you are trying to use SSL top connect to the server. Did you make the appropiate settings for SSL ? If you do not want to use SSL you have to disable the enforcement of encryption at the client and server side, otherwise the connection will be refused if not encrypted.

The settgin is stored at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\SuperSocketNetLib as of [3].

[1] http://support.microsoft.com/default.aspx?scid=kb;en-us;309398
[2] http://support.microsoft.com/default.aspx?scid=kb;en-us;302409
[3] http://support.microsoft.com/default.aspx?scid=kb;en-us;841695

HTH, jens Suessmeyer.

http://www.sqlserver2005.de

|||

I am moving the thread to the data access forum, because there's no login failure message in the log.

Thanks
Laurentiu

|||

Thanks for your email.

I check the settings at the key referred to and found the following:

ab (Default) REG_SZ (value not set)

ab Protocolorder REG_MULTI_SZ tcp np

and the key contains a folder TDS with:

ab (Default) REG_SZ (value not set)

ab (local) REG_SZ 7.0

ab COMPAC REG_SZ 7.0

Do you see any changes that need to be made?

Thanks

|||

Hi,

It is possilbe that if you enabled client-side 'force encryption' option but the sql server does not support SSL from server-side.

Please open Client Network Utility, (you can run cliconfg.exe from the Run menu). Make sure that 'foce encryption' is not checked.

Thx, -Justin

|||

Mostlikely, this is because your server does not have trusted certificate and client driver is configured to "Force protocol encryption". If you truly need to force encryption, you can take a look at

http://blogs.msdn.com/sql_protocols/archive/2005/10/04/476705.aspx

Otherwise, you can use cliconfg.exe to turn off "Force protocol encryption". option.

[Ask]Getting files from pocket pc emulator to desktop pc

hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ?

thanx b4

Moving this thread to SQL Mobile forum where it has got better chances of being answered.

-Thanks,

Mohit

|||

Yes, you sure can copy this file (e.g. by using file explorer on emulator and network drive on PC). But you can't use it on desktop.

|||Can you tell me what should i do to copy the file, more specifically (step by step) ?
I don't have a plan to use it on desktop, I just want to copy the .sdf file from emulator to desktop, then to the real pocket pc

thanx
|||

Please see this (don't mind it mentions wireless network, work the same way on emulator):

http://pocketpccentral.net/help/browsewlan.htm

[2005] How do I script out all indexes?

Hello,
we are using Sql Server 2005 Managament Studio.
Can someone tell me how I can script out all DROP/CREATE INDEXES for a particular database?
We only want to script out the INDEXES, not the tables.
Please advise.
Thanks.
`LeYou can try using a (free) tool I wrote, called scriptdb.exe.

It scripts out all objects (including indexes). The script for each object is created in a separate file. It would be a simple matter to alter the tool so it only scripts the indexes (the source is available so you could do it yourself). Or you can just run it as is and script out all the objects, and throw away what you don't want if all you care about are indexes.

You can get it here: http://www.elsasoft.org/tools.htm

Alternatively, in SSMS, you could try using the Generate Scripts Wizard for this, but it won't do both drop and create at the same time. only drop OR create. not both.

Hope this helps!|||Thanks for the offer, but my company has a policy against 3rd party executables.

As for Sql Server Management Studio, I cannot seem to find anyplace to script out ONLY the indexes.

Are there other suggestions?

`Le|||you appear to be right, GSW won't script the index separate from the table.

even if you have a policy against 3rd party executables, you can still use scriptdb since I posted the source code.

Just build it yourself using VS or csc.exe and then it's *your* executable ;)