TonySaucedo
Tue Apr 11 23:48:01 CDT 2006
I guess I was not sure how to create an ID column that enumerates
automatically. I guess the attempts I tried required the user to enter the
value and not automatically.
I would like to create a column called Case# and have it start at a certain
value or number and increment automatically.
"Robin Meuré" wrote:
> Why do you want to change the ID? You can also hide this column and create
> your own ID'ing column and show this
>
> "Tony Saucedo" wrote:
>
> > Bill,
> >
> > Actually MSDE does support remote connections, we use it all the time. But
> > I guess it's the Sharepoint stuff, since I noticed there's no SQL Server
> > service that shows up in the Service Manager which was installed.
> >
> > I will proabably ended having to move this over to a Production SQL Server
> > once our test site is complete.
> >
> > BTW, do you know how to rename the column ID that is in the "HelpDesk"
> > Template?
> >
> > Thanks.
> > Tony
> >
> > "Bil Simser [SPS MVP]" wrote:
> >
> > > You have to use windows auth to connect, but you won't be able to do it
> > > remotely as MSDE doesn't support remote connections.
> > >
> > > And FTR, please stay out of the database as there's nothing you need to
> > > access there via Enterprise Manager, Query Analyzer, or other tools. All
> > > access to SharePoint information should be done via the web interface or
> > > the API.
> > >
> > > --
> > > Bil Simser
> > > SharePoint MVP, BSc., MCSD
> > > Calgary, Alberta
> > >
http://weblogs.asp.net/bsimser
> > >
> > >
> > >
> > > "Tony Saucedo" <TonySaucedo@discussions.microsoft.com> wrote in message
> > > news:60D8AD5E-4C4F-4849-9C9F-663441CE627A@microsoft.com:
> > >
> > > > I just installed Sharepoint Services on W2K3 Server used the defaults.
> > > > Created a couple of sites.
> > > >
> > > > Now I wanted to look at the database (MSDE) that was installed.
> > > > I tried using Enterprise Mgr but was unsuccessful when providing the
> > > > \\servername\sharepoint_instance (MSSQL$SHAREPOINT).
> > > > Neither Windows Auth or SQL Auth worked. I am not sure what the 'sa' password.
> > > >
> > > > What am I missing?
> > > >
> > > > What is the default 'sa' password or admin account for this installation?
> > > >
> > > > Thanks.
> > > > Tony
> > >
> > >