Fresh installation and no access

I've just installed MS SQL Server Express Advanced Editon and when loggin in
with my user account(using Widnows Vista) I have no permission at all. I
cant create a new database and I cant change any settings. Then I tried
logging on with the sa account. Then I got this error message:
TITLE: Connect to Server
--
Cannot connect to KULVIS\SQLEXPRESS.
ADDITIONAL INFORMATION:
Login failed for user 'sa'. The user is not associated with a trusted SQL
Server connection. (Microsoft SQL Server, Error: 18452)
For help, click:
http://go.microsoft.com/fwlink?Prod...52&LinkId=20476
BUTTONS:
OK
--
StigStig
During the instalation process, did you set up SQL Server to Windows only
or Mixed Authentication?
I don't have Windows Vista to test the problem, sorry.
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:EE6F52D2-732E-4A27-8285-3B613E1AA262@.microsoft.com...
> I've just installed MS SQL Server Express Advanced Editon and when loggin
> in with my user account(using Widnows Vista) I have no permission at all.
> I cant create a new database and I cant change any settings. Then I tried
> logging on with the sa account. Then I got this error message:
> TITLE: Connect to Server
> --
> Cannot connect to KULVIS\SQLEXPRESS.
> --
> ADDITIONAL INFORMATION:
> Login failed for user 'sa'. The user is not associated with a trusted SQL
> Server connection. (Microsoft SQL Server, Error: 18452)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...52&LinkId=20476
> --
> BUTTONS:
> OK
> --
> Stig|||I thought I set it to Mixed Authentication but now I'm not sure. Is there
any way to change this setting without reinstalling it?
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:eGrlvS%23MHHA.4928@.TK2MSFTNGP06.phx.gbl...
> Stig
> During the instalation process, did you set up SQL Server to Windows
> only or Mixed Authentication?
> I don't have Windows Vista to test the problem, sorry.
>
>
> "Stig Kulvedrsten" <stig@.spire.as> wrote in message
> news:EE6F52D2-732E-4A27-8285-3B613E1AA262@.microsoft.com...
>|||Sure
SELECT SERVERPROPERTY('IsIntegratedSecurityOnly
') AS
[IsIntegratedSecurityOnly]
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:D25D73BE-1B57-4A7D-9509-52E48E9322C7@.microsoft.com...
>I thought I set it to Mixed Authentication but now I'm not sure. Is there
>any way to change this setting without reinstalling it?
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:eGrlvS%23MHHA.4928@.TK2MSFTNGP06.phx.gbl...
>|||ok. i ran the query and got 1 as a result.
but how can I change this setting if I dont have any permission?
Stig
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uo6brH$MHHA.1240@.TK2MSFTNGP03.phx.gbl...
> Sure
> SELECT SERVERPROPERTY('IsIntegratedSecurityOnly
') AS
> [IsIntegratedSecurityOnly]
>
>
>
>
> "Stig Kulvedrsten" <stig@.spire.as> wrote in message
> news:D25D73BE-1B57-4A7D-9509-52E48E9322C7@.microsoft.com...
>|||If you don't , you cannot, unless changing a value in registry ( I don't
recommend you)
You must create a login (to allow connect to SQL Server) then a user to be
mapped to the login to allow access to specific database
"Stig Kulvedrsten" <stig@.spire.as> wrote in message
news:C945D488-FD52-49EF-9CF0-9D2CC27E64E0@.microsoft.com...
> ok. i ran the query and got 1 as a result.
> but how can I change this setting if I dont have any permission?
> Stig
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:uo6brH$MHHA.1240@.TK2MSFTNGP03.phx.gbl...
>|||You're not getting access because you're not an administrator when you log
in. In previous OS's you had administrator permissions on the database
because you were an administrator in Windows and that made you an
administrator in SQL. In Vista you don't run as an admin by default. You
have to make yourself a Windows admin before you log into SQL so you have
permissions to change the security settings. By the way, this is why they
say you should be running SQL Server SP2 on Vista.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:ODSbuP$MHHA.1240@.TK2MSFTNGP03.phx.gbl...
> If you don't , you cannot, unless changing a value in registry ( I don't
> recommend you)
> You must create a login (to allow connect to SQL Server) then a user to be
> mapped to the login to allow access to specific database
>
>
> "Stig Kulvedrsten" <stig@.spire.as> wrote in message
> news:C945D488-FD52-49EF-9CF0-9D2CC27E64E0@.microsoft.com...
>

Freeze table header

When exporting a report to excel, Is there any way to keep the table
header from scrolling up in the excel output when a user scrolls down
through the data?
I noticed that anything that's put above the page header is frozen
when the report is exported to excel.
But when I tried placing the table headers in text boxes and putting
them in the page header area, the headers are out of alignment when
it's exported to excel.On the table you can have the header freeze when you scroll.Right click for
properties and last option.
Amarnath
"bevarg" wrote:
> When exporting a report to excel, Is there any way to keep the table
> header from scrolling up in the excel output when a user scrolls down
> through the data?
> I noticed that anything that's put above the page header is frozen
> when the report is exported to excel.
> But when I tried placing the table headers in text boxes and putting
> them in the page header area, the headers are out of alignment when
> it's exported to excel.
>|||I have that option set to True but it doesn't work when I export it to
Excel. It seems to work only when you are viewing the report within
report manager and you have multiple pages.
On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
wrote:
> On the table you can have the header freeze when you scroll.Right click for
> properties and last option.
> Amarnath
> "bevarg" wrote:
> > When exporting a report to excel, Is there any way to keep the table
> > header from scrolling up in the excel output when a user scrolls down
> > through the data?
> > I noticed that anything that's put above the page header is frozen
> > when the report is exported to excel.
> > But when I tried placing the table headers in text boxes and putting
> > them in the page header area, the headers are out of alignment when
> > it's exported to excel.|||On Apr 26, 1:16 pm, bevarg <benovargh...@.gmail.com> wrote:
> I have that option set to True but it doesn't work when I export it to
> Excel. It seems to work only when you are viewing the report within
> report manager and you have multiple pages.
> On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > On the table you can have the header freeze when you scroll.Right click for
> > properties and last option.
> > Amarnath
> > "bevarg" wrote:
> > > When exporting a report to excel, Is there any way to keep the table
> > > header from scrolling up in the excel output when a user scrolls down
> > > through the data?
> > > I noticed that anything that's put above the page header is frozen
> > > when the report is exported to excel.
> > > But when I tried placing the table headers in text boxes and putting
> > > them in the page header area, the headers are out of alignment when
> > > it's exported to excel.
You are correct. Unfortunately, you would have to manually set this in
Excel (via Window -> Freeze Panes).
Regards,
Enri|||What you can do is to just align all the table header on the header of the
page then remove the table header, so that header will be frozen. yes page
header is frozen and not table header.
Amarnath
"bevarg" wrote:
> I have that option set to True but it doesn't work when I export it to
> Excel. It seems to work only when you are viewing the report within
> report manager and you have multiple pages.
> On Apr 25, 5:24 am, Amarnath <Amarn...@.discussions.microsoft.com>
> wrote:
> > On the table you can have the header freeze when you scroll.Right click for
> > properties and last option.
> >
> > Amarnath
> >
> > "bevarg" wrote:
> > > When exporting a report to excel, Is there any way to keep the table
> > > header from scrolling up in the excel output when a user scrolls down
> > > through the data?
> >
> > > I noticed that anything that's put above the page header is frozen
> > > when the report is exported to excel.
> > > But when I tried placing the table headers in text boxes and putting
> > > them in the page header area, the headers are out of alignment when
> > > it's exported to excel.
>
>

Freeze Report Header

Is there a way to freeze the report header so when a user is looking at the
report, on the web, and they scroll down the page that they can always see
the header?
Thanks,
Jasonthis is not yet acheived by microsoft but it is to be done by them (as
they said so ) in any next version wait till that|||Yes, fixed headers will be available in SQL Server 2005 Reporting Services.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"** Spirits **" <muhammadhammad78@.gmail.com> wrote in message
news:1113385952.494987.10490@.z14g2000cwz.googlegroups.com...
> this is not yet acheived by microsoft but it is to be done by them (as
> they said so ) in any next version wait till that
>

Freeze panes when report is exported to Excel

I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel?

I have the feeling the answer is no, but I thought I'd check.

Hi, there is a property named FixedHeader. I didn′t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn′t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

I'm having the exact same issue. Has anyone been able to accomplish this successfully?

Jens Suessmeyer: I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) am trying to do.

The only option that I see out there is purchasing OfficeWriter by SoftArtisans or just try to figure out how they do it and write the code (It seems they use scripts... not sure yet).

Any ideas anybody? (or links :) )

|||Sorry, we don't support programmatic setting of Freeze Panes. The only

thing Excel export uses Freeze Panes for is for the PageHeader when

SimpleHeaders=false (the default).

Excel export ignores the FixedHeaders property.

OfficeWriter would support your use case, because you author the report in Excel and can set the freeze panes when designing the report. You could also use the ExcelApplication class from OfficeWriter to modify the output file.

OfficeWriter doesn't use VBA scripting, if that's what you mean; it reads, modifies, and writes the binary BIFF8 Excel format.

Freeze panes when report is exported to Excel

I am using RS 2005 and emailing reports in Excel to my end users. Is it possible to set the report in VS.Net to freeze the panes so that the user will always see the column A when they scroll to the right once they view the report in Excel?

I have the feeling the answer is no, but I thought I'd check.

Hi, there is a property named FixedHeader. I didn′t try that this deep yet (only for table header) , but it would be worth a try. I guess you will your own rendering extension as the rendering for Excel didn′t brought back the right results with fixed headers for me (worked well in HTML, but not in Excel)

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

I'm having the exact same issue. Has anyone been able to accomplish this successfully?

Jens Suessmeyer: I tried the property option but that didn’t work for me. The closest to what I’m trying to accomplish (that I’ve gotten); it’s using a report header which freezes the first row (or whatever u have in the header) yet by design it doesn’t accomplish what I (and rs12345) am trying to do.

The only option that I see out there is purchasing OfficeWriter by SoftArtisans or just try to figure out how they do it and write the code (It seems they use scripts... not sure yet).

Any ideas anybody? (or links :) )

|||Sorry, we don't support programmatic setting of Freeze Panes. The only

thing Excel export uses Freeze Panes for is for the PageHeader when

SimpleHeaders=false (the default).

Excel export ignores the FixedHeaders property.

OfficeWriter would support your use case, because you author the report in Excel and can set the freeze panes when designing the report. You could also use the ExcelApplication class from OfficeWriter to modify the output file.

OfficeWriter doesn't use VBA scripting, if that's what you mean; it reads, modifies, and writes the binary BIFF8 Excel format.

Frant permission to exec a DTS

Hi,
I created a DTS job, I need win user group able to exec that DTS through
TDYrun untility.
How do I grant permssion to that group
ThanksI guess this user (domain\username) should have administrative rights
on your SQL Server Box.

Frant permission to exec a DTS

Hi,
I created a DTS job, I need win user group able to exec that DTS through
TDYrun untility.
How do I grant permssion to that group
ThanksI guess this user (domain\username) should have administrative rights
on your SQL Server Box.

Fragmented System Tables

I have found that a bunch of our tables were highly fragemented. (in some cases as much as 80%)
I used DBCC dBReindex to correct all the user tables, but how do I defrag the system table indexes?
Thanks--all except clustered indexes on sysobjects and sysindexes
dbcc dbrepair(@.dbname, repairindex, @.tabname, @.indid)

-- And an example
exec sp_dboption 'YourDatabase','single user','true'
dbcc dbrepair('YourDatabase', repairindex, 'syscolumns', 1)
exec sp_dboption 'YourDatabase','single user','false'

-- And better encapsulated in undocumented MS SP
exec sp_dboption 'YourDatabase','single user','true'
exec sp_fixindex 'YourDatabase', 'syscolumns', 1)
exec sp_dboption 'YourDatabase','single user','false'|||Originally posted by ispaleny
--all except clustered indexes on sysobjects and sysindexes
dbcc dbrepair(@.dbname, repairindex, @.tabname, @.indid)

-- And an example
exec sp_dboption 'YourDatabase','single user','true'
dbcc dbrepair('YourDatabase', repairindex, 'syscolumns', 1)
exec sp_dboption 'YourDatabase','single user','false'

-- And better encapsulated in undocumented MS SP
exec sp_dboption 'YourDatabase','single user','true'
exec sp_fixindex 'YourDatabase', 'syscolumns', 1)
exec sp_dboption 'YourDatabase','single user','false'

Thank you very much,

2 additional related questions

1) Can this be set to run weekly via a scheduled Job?
2) Can this be done with users still connected

(we have users connected 24/7 via internet)

Thanks again.|||Q1) Can this be set to run weekly via a scheduled Job?
A1) Yes. But you must add a script for disconnecting users.

Q2) Can this be done with users still connected
A2) No. The database must be in a single user mode.

I must be a funny job to maintain a living database :)
Let me know how you solved it.

Good luck !|||If you have set up your web site to have one place where the connections are made AND if the database is not THAT huge, you could replicate it, run the corrections, point the connections to the "new" database, replace the old one and go on.

That should be something that could certainly be automated. Might be more work than its worth tho...